Search Results gl_ledgers_public_v




Overview
Explore in AI Chat

Overview

GL_LEDGERS_PUBLIC_V is a public, API-oriented database view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the General Ledger (GL) product family and exposes the definition of accounting ledgers as configured within the Ledger architecture introduced in Release 12. Unlike the internal GL_LEDGERS table, which carries the full set of ledger definition columns, this view presents a curated column list intended for public consumption by application code, concurrent programs, and custom integrations.

The view is marked VALID in the data dictionary and is the recommended read interface for retrieving ledger attributes such as the chart of accounts, functional currency, accounting calendar, and the various ledger-level processing options. Because it is published under the APPS schema, it is queryable by any enabled EBS database user with the appropriate grants, making it a stable contract for reporting and interface development across both 12.1.1 and 12.2.2.

Underlying Base Objects

Per the documented metadata, GL_LEDGERS_PUBLIC_V is defined over a single referenced base object: the GL_LEDGERS synonym. GL_LEDGERS is the master definition table for ledgers in the R12 data model, and it in turn typically resolves to the underlying GL_LEDGERS table owned by the GL schema. The view performs a straightforward projection of columns from this table, applying one derived transformation rather than joining additional tables.

Notably, the view derives MRC_LEDGER_TYPE_CODE by decoding the ALC_LEDGER_TYPE_CODE column: a value of 'SOURCE' maps to 'P', 'TARGET' maps to 'R', and all other values map to 'N'. This DECODE preserves backward compatibility with the multiple reporting currency (MRC) concepts carried forward from earlier releases, allowing MRC-aware code to continue functioning against the R12 ledger model.

Key Columns

The view exposes the principal ledger attributes required to drive accounting behavior:

Common Use Cases and Queries

The view is most frequently used to resolve ledger properties during setup validation, reporting, and integration. A typical query retrieves the functional currency and calendar for a specific ledger:

  • SELECT ledger_id, name, currency_code, period_set_name, accounted_period_type FROM apps.gl_ledgers_public_v WHERE ledger_id = :p_ledger_id;
  • Listing all enabled ledgers with their key processing flags: SELECT name, short_name, chart_of_accounts_id, enable_je_approval_flag, enable_budgetary_control_flag FROM apps.gl_ledgers_public_v ORDER BY name;
  • Identifying consolidation or translation-enabled ledgers: SELECT ledger_id, name, consolidation_ledger_flag FROM apps.gl_ledgers_public_v WHERE consolidation_ledger_flag = 'Y';
  • Joining to GL_CODE_COMBINATIONS using the retained earnings CCID to obtain account details for reporting extracts.

Because the view is a thin projection over GL_LEDGERS, it incurs no significant performance overhead and is safe for read-only integration use. Custom code should reference GL_LEDGERS_PUBLIC_V rather than the base table to remain aligned with Oracle's supported public interface.