DIS Workbooks, Folders, Items and LOVs – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Discoverer workbooks, their owners, folders, items and item class LOVs, derived from dependency table eul5_elem_xrefs.
Report Parameters
Workbook, Folder, View Name, Workbook Id, Access Count within x Days, Show Active only, Display Level, End User Layer
Oracle EBS Tables Used
dba_views, eul5_documents, eul5_elem_xrefs, “_CURRENT_EDITION_OBJ”, view$, user$, eul5_objs, eul5_qpp_stats, eul5_expressions, eul5_domains, eul5_key_cons, eul5_functions
Report Categories
Related Reports
DIS Folders, Business Areas, Items and LOVs, DIS Items, Folders and Formulas, DIS Worksheet Execution History, DIS Access Privileges, DIS Workbook Export Script, DIS Business Areas, DIS Workbook Import Validation, DIS Worksheet Execution Summary, DIS Worksheet SQLs
Running This SQL Without Blitz Report
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.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | DIS Workbooks, Folders, Items and LOVs 28-Mar-2026 080822.xlsx |
| Blitz Report™ XML Import | DIS_Workbooks_Folders_Items_and_LOVs.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/dis-workbooks-folders-items-and-lovs/ |
DIS Workbooks, Folders, Items and LOVs
Description
This report provides a deep dive into the structural dependencies of Oracle Discoverer workbooks. It maps workbooks to their underlying folders, items, and List of Values (LOV) item classes, derived from the dependency table eul5_elem_xrefs.
Key insights provided by this report include:
- Workbook Dependencies: Identifies which database views and folders are used by specific workbooks.
- Item Usage: Lists the specific items (columns) used within workbooks, helping to identify critical data elements.
- LOV Analysis: Shows item class LOVs associated with workbook items.
- Usage Metrics: Includes access counts to help determine the relevance and activity level of workbooks.
This detailed dependency mapping is essential for impact analysis when changing database objects or EUL definitions, as well as for planning the migration of complex reports to Blitz Report.
Parameters
- Workbook: Filter by workbook name.
- Folder: Filter by EUL folder name.
- View Name: Filter by the underlying database view name.
- Workbook Id: Filter by specific workbook ID.
- Access Count within x Days: Filter workbooks based on recent usage activity.
- Show Active only: Toggle to show only active workbooks.
- Display Level: Control the granularity of the report output.
- End User Layer: Select the EUL to analyze.
Used Tables
dba_views: Database views metadata.eul5_documents: Discoverer workbook definitions.eul5_elem_xrefs: Cross-references between EUL elements.eul5_objs: EUL objects (folders).eul5_qpp_stats: Query statistics.eul5_expressions: EUL expressions (calculations).eul5_domains: EUL domains (LOVs).eul5_key_cons: Key constraints (joins).eul5_functions: EUL functions.
Categories
- Enginatics: Technical analysis tool for Discoverer environments.
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
© 2026 Enginatics