GL Ledger Sets – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: General Ledger · all General Ledger reports
Overview
Master data report showing GL ledger sets and included ledgers.
Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.
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
FND Responsibility Access, FND Responsibilities, GL Data Access Sets, GL Ledgers and Legal Entities, IBY Payment Process Request Details, GL Setup Upload, AR Customer Upload, AP Supplier Upload, Blitz Report Security
Running This SQL Without Blitz Report
The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | GL Ledger Sets 04-Apr-2026 123137.xlsx |
| Blitz Report™ XML Import | GL_Ledger_Sets.xml |
| SQL Source | GL Ledger Sets.sql |
| Full Report 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
© Enginatics GmbH