DIS End User Layers – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Discoverer end user layers
Report Parameters
End User Layer, History days
Oracle EBS Tables Used
xxen_report_parameter_lovs, dba_synonyms, dba_tables, dba_objects, &eul_object_counts, xxen_discoverer_workbook_xmls, xxen_discoverer_workbooks, xxen_discoverer_sheets, xxen_report_templates_v, xxen_reports_v
Report Categories
Related Reports
DIS Workbook Import Validation, DIS Migration identify missing EulConditions, DBA ORDS Configuration Validation, DBA Blitz Report ORDS Configuration, DIS Discoverer and Blitz Report Users, Blitz Report Security, DIS Workbooks, Folders, Items and LOVs, DBA SGA Active Session History, DBA AWR Active Session History
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 End User Layers 28-Mar-2026 080435.xlsx |
| Blitz Report™ XML Import | DIS_End_User_Layers.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/dis-end-user-layers/ |
Case Study & Technical Analysis
Abstract
The DIS End User Layers report provides technical metadata about the Discoverer End User Layers (EULs) installed in the database. An EUL is the schema that holds all Discoverer metadata (Business Areas, Folders, Workbooks). Large organizations often have multiple EULs (e.g., EUL_US, EUL_EU) to segregate reporting content.
Technical Analysis
Core Components
- EUL Owner: The database schema that owns the EUL tables (typically
EUL5_USor similar). - Version: The version of the EUL (e.g., 5.1.1), which is critical for compatibility.
- Object Counts: Summaries of how many workbooks, folders, and items exist in each EUL.
Key Tables
DBA_USERS: To identify EUL schemas.XXEN_DISCOVERER_WORKBOOKS: Custom views used to analyze the EUL content.
Operational Use Cases
- Environment Assessment: Quickly understanding the reporting landscape of a new EBS instance.
- Consolidation: Planning the merge of multiple regional EULs into a single global EUL.
- Backup/Restore: Verifying that all EUL schemas are included in backup strategies.
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