GL Ledger Sets – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Master data report showing GL ledger sets and included ledgers.
Report Parameters
Ledger Set, Chart of Accounts
Oracle EBS Tables Used
gl_ledgers, gl_ledger_sets_v, gl_ledger_set_norm_assign_v
Report Categories
Related Reports
GL Data Access Sets, CAC Cost vs. Planning Item Controls, FND Responsibilities, CAC New Items, CAC Item vs. Component Include in Rollup Controls, CAC ICP PII Inventory and Intransit Value (Period-End), CAC Inventory and Intransit Value (Period-End), CAC Material Overhead Setup, CAC Inventory Organization Summary, CAC Inventory Pending Cost Adjustment - No Currencies
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 Ledger Sets 04-Apr-2026 123137.xlsx |
| Blitz Report™ XML Import | GL_Ledger_Sets.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/gl-ledger-sets/ |
GL Ledger Sets - Case Study & Technical Analysis
Executive Summary
The GL Ledger Sets report is a configuration analysis tool that documents the setup of Ledger Sets within the Oracle General Ledger. Ledger Sets allow organizations to group multiple ledgers (e.g., by region, country, or line of business) to perform collective processing such as opening/closing periods, running reports, or performing revaluation. This report helps visualize these groupings and verify that the correct ledgers are included in each set.
Business Use Cases
- Configuration Verification: Ensures that a “Global” or “Regional” ledger set actually contains all the intended ledgers (e.g., verifying that the newly created “France” ledger was added to the “EMEA” ledger set).
- Period Close Management: Assists in troubleshooting why a period might not be closed for a specific entity by confirming its membership in the Ledger Set used for the “Close Period” program.
- Reporting Hierarchy: Validates the structures used for consolidated reporting, ensuring that data aggregation at the Ledger Set level will be accurate.
- Access Control: Since Data Access Sets can be assigned to Ledger Sets, this report helps map out the scope of access granted to users.
Technical Analysis
Core Tables
GL_LEDGER_SETS_V: A view that lists the defined Ledger Sets.GL_LEDGER_SET_NORM_ASSIGN_V: Contains the normative assignments, defining which ledgers (or other ledger sets) belong to a parent ledger set.GL_LEDGERS: Stores the details of the individual ledgers.
Key Joins & Logic
- Set Membership: The query joins
GL_LEDGER_SETS_V(the parent) toGL_LEDGER_SET_NORM_ASSIGN_V(the mapping) and then toGL_LEDGERS(the child) to list the members. - Chart of Accounts Validation: Typically, all ledgers in a set must share the same Chart of Accounts and Calendar. The report likely includes columns to validate this consistency.
- Recursive Logic: Ledger Sets can potentially contain other Ledger Sets. The report logic (or the underlying view) handles the flattening of this hierarchy to show the ultimate list of ledgers.
Key Parameters
- Ledger Set: The specific set to analyze.
- Chart of Accounts: Filter to show sets belonging to a specific COA structure.
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