GL Ledgers and Legal Entities – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Master data report showing ledger set, ledger name, ledger category, currency, legal entity, and balancing segment across all ledgers and legal entities.
Report Parameters
Ledger, Country
Oracle EBS Tables Used
gl_ledger_set_norm_assign_v, gl_ledgers, gl_legal_entities_bsvs, fnd_flex_values_vl, fnd_id_flex_structures_vl, gl_ledger_config_details, xle_firstparty_information_v, fnd_territories_vl
Report Categories
Related Reports
FND Responsibility Access, CAC Inventory Organization Summary, CAC Interface Error Summary, CAC Material Account Detail, CAC ICP PII Material Account Detail, CAC ICP PII Material Account Summary, CAC ICP PII WIP Pending Cost Adjustment, CAC Manufacturing Variance
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 | GL Ledgers and Legal Entities 11-Mar-2020 085737.xlsx |
| Blitz Report™ XML Import | GL_Ledgers_and_Legal_Entities.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/gl-ledgers-and-legal-entities/ |
GL Ledgers and Legal Entities - Case Study & Technical Analysis
Executive Summary
The GL Ledgers and Legal Entities report is a comprehensive master data report that maps the complex hierarchy of the Oracle E-Business Suite financial structure. It visualizes the relationships between Ledger Sets, Ledgers, Legal Entities, and Balancing Segments. This report is essential for verifying the enterprise structure setup, ensuring that legal entities are correctly assigned to ledgers and that balancing segment values (Company Codes) are properly mapped.
Business Use Cases
- Enterprise Structure Verification: Validates that the system configuration matches the designed corporate structure (e.g., “Does the UK Legal Entity correctly roll up to the UK Ledger?”).
- Balancing Segment Audit: Ensures that every Balancing Segment Value (BSV) is assigned to a Legal Entity, preventing “unassigned” transactions that could cause intercompany accounting failures.
- Merger & Acquisition Integration: Assists in planning the integration of new entities by providing a clear picture of the existing ledger and legal entity landscape.
- Tax Reporting Setup: Verifies that Legal Entities (which are the tax reporting units) are associated with the correct Ledgers and Currencies.
Technical Analysis
Core Tables
GL_LEDGERS: The central table defining the ledgers.XLE_ENTITY_PROFILES(viaXLE_FIRSTPARTY_INFORMATION_V): Stores Legal Entity definitions.GL_LEGAL_ENTITIES_BSVS: The mapping table that assigns Balancing Segment Values to Legal Entities.GL_LEDGER_CONFIG_DETAILS: Stores configuration details linking ledgers to legal entities.GL_LEDGER_SET_NORM_ASSIGN_V: Resolves Ledger Set memberships.
Key Joins & Logic
- Hierarchy Traversal: The query likely starts from
GL_LEDGERSand joins toGL_LEDGER_CONFIG_DETAILSto find the associated Legal Entities. - BSV Mapping: It joins to
GL_LEGAL_ENTITIES_BSVSto list the specific segment values (e.g., Company 01, 02) assigned to each entity. - Ledger Set Expansion: Uses
GL_LEDGER_SET_NORM_ASSIGN_Vto show which Ledger Sets these ledgers belong to, providing a top-down view. - Flexfield Resolution: Joins to
FND_FLEX_VALUES_VLto display the descriptions of the balancing segment values.
Key Parameters
- Ledger: Filter by a specific Ledger or Ledger Set.
- Country: Filter by the country defined in the Legal Entity or Location.
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