| layout | default |
|---|---|
| title | DIS Worksheet SQLs | Oracle EBS SQL Report |
| description | Discoverer worksheet SQL queries. While the workbook documents are stored in a binary format in eul5documents.docdocument and it's difficult extract their… |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, DIS, Worksheet, SQLs, ams_discoverer_sql, eul5_qpp_stats |
| permalink | /DIS%20Worksheet%20SQLs/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Discoverer worksheet SQL queries. While the workbook documents are stored in a binary format in eul5_documents.doc_document and it's difficult extract their content (https://community.oracle.com/thread/2494216), there is an active trigger function select ef.* from eul_us.eul5_functions ef where ef.fun_name='eul_trigger$post_save_document' writing each worksheets' SQL query to table ams_discoverer_sql
Workbook, Worksheet, Access Count within x Days, Show Active only, End User Layer
ams_discoverer_sql, eul5_qpp_stats
DIS Worksheet Execution History, DIS Workbook Import Validation, DIS Discoverer and Blitz Report Users, DIS End User Layers, DIS Workbooks, Folders, Items and LOVs, DIS Folders, Business Areas, Items and LOVs, DIS Workbook Export Script, DIS Access Privileges, DIS Worksheet Execution Summary
Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.
| Resource | Link |
|---|---|
| Excel Example Output | DIS Worksheet SQLs 04-Jan-2019 135604.xlsx |
| Blitz Report™ XML Import | DIS_Worksheet_SQLs.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/dis-worksheet-sqls/ |
This report extracts the underlying SQL queries for Oracle Discoverer worksheets. Since Discoverer stores workbook definitions in a binary format within eul5_documents, extracting the SQL directly is difficult. This report relies on a trigger-based mechanism (using eul_trigger$post_save_document) that captures the SQL query at the time of saving and stores it in a custom table ams_discoverer_sql.
This tool is invaluable for:
- Documentation: Automatically documenting the logic behind legacy reports.
- Migration: Extracting SQL to migrate reports to other platforms like Blitz Report or BI Publisher.
- Auditing: Reviewing the complexity and efficiency of user-generated queries.
- Workbook: Filter by workbook name.
- Worksheet: Filter by worksheet name.
- Access Count within x Days: Filter based on recent usage.
- Show Active only: Toggle to show only active worksheets.
- End User Layer: Select the EUL to query.
ams_discoverer_sql: Custom table storing captured Discoverer SQL queries.eul5_qpp_stats: Query performance statistics.
- Enginatics: Technical utility for Discoverer management and migration.
- 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
© 2026 Enginatics