Skip to content

DIS End User Layers

Directory actions

More options

Directory actions

More options

Latest commit

 

History

History

DIS End User Layers

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
DESCRIPTION.md
DESCRIPTION.md
 
 
DIS End User Layers.sql
DIS End User Layers.sql
 
 
README.md
README.md
 
 

README.md

layout default
title DIS End User Layers | Oracle EBS SQL Report
description Discoverer end user layers – Oracle E-Business Suite SQL report
keywords Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, DIS, End, User, Layers, xxen_report_parameter_lovs, dba_synonyms, dba_tables
permalink /DIS%20End%20User%20Layers/

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

Enginatics

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_US or 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

© 2026 Enginatics