DIS Worksheet SQLs – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Discoverer · all Discoverer reports
Overview
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
Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.
Report Parameters
Workbook, Worksheet, Access Count within x Days, Show Active only, End User Layer
Oracle EBS Tables Used
ams_discoverer_sql, eul5_qpp_stats
Report Categories
Related Reports
DIS Converter Diagnostic Dump, DIS Workbook Import Validation, DIS Discoverer and Blitz Report Users, DIS Workbook Conversion Selection, DIS End User Layers, DIS Workbooks, Folders, Items and LOVs, DIS Folders, Business Areas, Items and LOVs, DIS Workbook Export Script, DIS Worksheet Execution History
Running This SQL Without Blitz Report
The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | DIS Worksheet SQLs 04-Jan-2019 135604.xlsx |
| Blitz Report™ XML Import | DIS_Worksheet_SQLs.xml |
| SQL Source | DIS Worksheet SQLs.sql |
| Full Report on Enginatics | www.enginatics.com/reports/dis-worksheet-sqls/ |
DIS Worksheet SQLs
Description
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.
Parameters
- 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.
Used Tables
ams_discoverer_sql: Custom table storing captured Discoverer SQL queries.eul5_qpp_stats: Query performance statistics.
Categories
- Enginatics: Technical utility for Discoverer management and migration.
Related Reports
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