| layout | default |
|---|---|
| title | DIS Migration identify missing EulConditions | Oracle EBS SQL Report |
| description | This report identifies the missing EUL conditions defined at the folder level. – Oracle E-Business Suite SQL report |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, DIS, Migration, identify, missing, xxen_discoverer_workbook_xmls, fnd_user, xmltable |
| permalink | /DIS%20Migration%20identify%20missing%20EulConditions/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
This report identifies the missing EUL conditions defined at the folder level.
Document Id
xxen_discoverer_workbook_xmls, fnd_user, xmltable, xxen_report_templates_v
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
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.
| 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/ |
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.
- XML Parsing: The report parses the exported Discoverer XML (
.eexfiles) stored inXXEN_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.
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.
- 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.
- 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