Search Results gl_ledger_le_v




Overview
Explore in AI Chat

Overview

GL_LEDGER_LE_V is an APPS-owned database view within the Oracle E-Business Suite General Ledger (GL) module. It provides a consolidated, reporting-friendly projection of ledger configuration data joined with legal entity, registration, and location information. The view is particularly relevant to environments that use the Ledger and Subledger Accounting architecture introduced in Release 12, where a primary ledger can be associated with one or more secondary ledgers as well as Accounting Legal Entity configurations. Rather than forcing report authors and integrators to reconstruct the relationship between ledgers, ledger configurations, configuration details, and legal entities, GL_LEDGER_LE_V exposes this data in a single flattened result set.

The view combines ledger attributes (such as ledger name, short name, category code, currency, chart of accounts, period set, and accounting method) with legal entity attributes (object identifier, legal entity name, and registration location details). This makes it suitable for cross-referencing ledgers to their assigned legal entities and for examining ledger relationship structures, including primary, secondary, and ALC ledger categories.

Underlying Base Objects

GL_LEDGER_LE_V is defined over seven documented base objects, all referenced through APPS synonyms:

The joins enforce a specific relationship set: the view restricts results to ledgers whose relationship type and target category satisfy primary, secondary, or ALC conditions, and only where the ledger is marked complete.

Key Columns

Common Use Cases and Queries

Typical uses include identifying the legal entity associated with each ledger, reporting on secondary and ALC ledger assignments, and validating multi-ledger configurations prior to period close or consolidation.

Sample query listing ledgers with their legal entities:

  • SELECT ledger_id, ledger_name, legal_entity_name, ledger_category_code, currency_code FROM apps.gl_ledger_le_v;

Sample query filtering to secondary ledgers linked to a given primary ledger:

  • SELECT ledger_id, ledger_name, primary_ledger_id, legal_entity_name FROM apps.gl_ledger_le_v WHERE ledger_category_code = 'SECONDARY' AND relationship_enabled_flag = 'Y';

Because legal entity and location columns are populated through outer joins, values may be null for ledgers lacking an assigned legal entity or registration.