DIS Migration identify missing EulConditions – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

This report identifies the missing EUL conditions defined at the folder level.

Report Parameters

Document Id

Oracle EBS Tables Used

xxen_discoverer_workbook_xmls, fnd_user, xmltable, xxen_report_templates_v

Report Categories

Enginatics

Related Reports

DIS End User Layers, DIS Workbook Import Validation, XDO Publisher Data Definitions, DBA ORDS Configuration Validation, Blitz Reports, DIS Discoverer and Blitz Report Users, DIS Worksheet SQLs, QP Customer Pricing Engine Request, Blitz Report Default Templates

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	None
Blitz Report™ XML Import	DIS_Migration_identify_missing_EulConditions.xml
Full SQL on Enginatics	www.enginatics.com/reports/dis-migration-identify-missing-eulconditions/

Case Study & Technical Analysis

Abstract

The DIS Migration identify missing EulConditions report is a specialized quality assurance tool for the Discoverer-to-Blitz Report migration process. In Discoverer, administrators can define “mandatory conditions” at the folder level (e.g., ORG_ID = 101) that are silently appended to every query using that folder. If these conditions are lost during migration, users might inadvertently access data they shouldn’t see.

Technical Analysis

Core Logic

• XML Parsing: The report parses the exported Discoverer XML (.eex files) stored in XXEN_DISCOVERER_WORKBOOK_XMLS.
• Gap Analysis: It compares the conditions found in the XML against the converted SQL in Blitz Report to ensure that folder-level filters were correctly carried over.

Key Tables

• XXEN_DISCOVERER_WORKBOOK_XMLS: A staging table holding the raw XML export of Discoverer workbooks.
• XMLTABLE: Used to query the XML structure directly within the database.

Operational Use Cases

• Security Validation: Ensuring that mandatory security filters (like Multi-Org access control) are preserved.
• Data Integrity: Preventing “cartesian product” reports caused by missing join conditions that were defined as folder conditions.

---

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