Skip to the content.

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

Enginatics, R12 only

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

Technical Analysis

Core Tables

Key Joins & Logic

Key Parameters


© Enginatics GmbH