DIS End User Layers – 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 end user layers
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
End User Layer, History days
Oracle EBS Tables Used
xxen_report_parameter_lovs, xxen_report_parameters_v, fnd_profile_options, dba_synonyms, dba_tables, dba_objects, 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 Converter Diagnostic Dump, DIS Migration identify missing EulConditions, DIS Workbook Conversion Selection, DBA ORDS Configuration Validation, Blitz Report Security, DBA Sessions
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 End User Layers 28-Mar-2026 080435.xlsx |
| Blitz Report™ XML Import | DIS_End_User_Layers.xml |
| SQL Source | DIS End User Layers.sql |
| Full Report 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
© Enginatics GmbH