Oracle EBS Discoverer Reports
17 ready-to-run SQL reports for Oracle E-Business Suite Discoverer, maintained by Enginatics and used in production at Oracle EBS customers worldwide. Each report page lists its parameters, the Oracle EBS tables it reads and an Excel example output. The most frequently used Discoverer tables in these reports are eul5_qpp_stats, eul5_documents, eul5_objs, xxen_discoverer_workbook_xmls, eul5_expressions, xxen_reports_v.
Run any of these reports in Excel in seconds: download Blitz Report™ free – your first 30 reports are free.
Discoverer SQL Reports
| Report | Description |
|---|---|
| DIS Access Privileges | Discoverer access privileges |
| DIS Business Areas | Summary report showing Discoverer business areas, with an access account showing how many times a business area’s folder was used within the past x number of… |
| DIS Converter Diagnostic Dump | Diagnostic dump of all metadata and flattened staging data needed to reproduce the xxenxdo Discoverer-to-Blitz conversion logic offline. Outputs a single… |
| DIS Discoverer and Blitz Report Users | Shows the user adoption for companies replacing Discoverer with Blitz Report in a phased approach. The report shows the number of Discoverer worksheets and… |
| DIS End User Layers | Discoverer end user layers |
| DIS Folders, Business Areas, Items and LOVs | Discoverer folders, business areas and items. Columns ‘Access Count’ and ‘Last Accessed’ shows how many times a folder was accessed by a worksheet within the… |
| DIS Import Performance | Query to review Discoverer to Blitz Report import performance, after running the ‘Blitz Report Discoverer Import’ concurrent program or mass migration script… |
| DIS Items, Folders and Formulas | Discoverer items (expressions) and folders (objects), including join conditions and formulas (calculated items) |
| DIS Migration identify missing EulConditions | This report identifies the missing EUL conditions defined at the folder level. |
| DIS Users | Discoverer end user layer users of different types (application user, responsibility, database user) |
| DIS Workbook Export Script | https://youtu.be/17Au11IBE Use this report to migrate Discoverer workbooks to Blitz Report. The migration process is described in the following link… |
| DIS Workbook Import Validation | Discoverer workbook migration validation report showing every workbook and worksheet next to its conversion state: whether the workbook xml is uploaded… |
| DIS Workbook Owner Export Script | This export of workbook owners is required to remotely export workbook XMLs on the Enginatics environments for customers requiring support when migrating from… |
| DIS Workbooks, Folders, Items and LOVs | Discoverer workbooks, their owners, folders, items and item class LOVs, derived from dependency table eul5elemxrefs. |
| DIS Worksheet Execution History | Discoverer worksheet access statistics from table eul5qppstats, including folder objects used. Parameter ‘Show Folder Details’ switches between aggregate and… |
| DIS Worksheet Execution Summary | Discoverer worksheet access statistic summary from table eul5qppstats to show the number of active Discoverer users, number of different workbooks and… |
| DIS Worksheet SQLs | Discoverer worksheet SQL queries. While the workbook documents are stored in a binary format in eul5documents.docdocument and it’s difficult extract their… |
Useful Links
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© Enginatics GmbH