Results for “gl_ledgers_u1”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

GL.GL_LEDGERS is the central ledger definition table in the Oracle E-Business Suite General Ledger module. It stores information about every ledger defined through Accounting Setup Manager as well as ledger sets defined through the Ledger Set form. In Oracle EBS 12.1.1 and 12.2.2, this table is the primary anchor for the multi-ledger architecture introduced with Subledger Accounting, supporting primary ledgers, secondary ledgers, reporting currencies, and ledger sets within a single consolidated model. Each row captures the ledger or ledger set name, short name, description, ledger currency, accounting calendar, chart of accounts, and a broad range of configuration flags governing journal processing, translation, reconciliation, budgeting, and security.

From a Data Vault modeling perspective, GL_LEDGERS classifies heuristically as a hub. It is a business-key-driven entity defined by stable identifiers, with the surrogate primary key LEDGER_ID separating unique ledger identities from descriptive attributes that could be modeled as satellites. Dependent configuration and reporting tables reference it as links and satellites.

Key Information Stored

The table contains 89 documented columns. The most operationally significant are listed below.

• LEDGER_ID — the ledger defining column and surrogate primary key (GL_LEDGERS_PK), also enforced by the unique index GL_LEDGERS_U2. This is the internal identifier referenced throughout the EBS data model.
• NAME — the ledger name. Enforced by the unique index GL_LEDGERS_U1, which is the object commonly searched as the business-key candidate.
• SHORT_NAME — a short ledger alias, enforced by the unique index GL_LEDGERS_U3.
• LEDGER_CATEGORY_CODE — designates PRIMARY, SECONDARY, or ALC (reporting currency) ledgers.
• OBJECT_TYPE_CODE — distinguishes a physical ledger from a ledger set.
• CHART_OF_ACCOUNTS_ID — the key flexfield structure defining the accounting flexfield for the ledger.
• CURRENCY_CODE — the ledger's functional currency, tied to FND_CURRENCIES.
• PERIOD_SET_NAME and ACCOUNTED_PERIOD_TYPE — identify the accounting calendar and period type used for posting.
• CONFIGURATION_ID — links each ledger back to its definition in GL_LEDGER_CONFIGURATIONS.
• COMPLETION_STATUS_CODE — indicates whether accounting setup is Not Started, Incomplete, or Complete.
• IMPLICIT_LEDGER_SET_ID and IMPLICIT_ACCESS_SET_ID — self-referencing pointer and security linkage to access sets.
• LATEST_OPENED_PERIOD_NAME — the current open period used by period-control logic.
• Retained earnings and suspense columns (RET_EARN_CODE_COMBINATION_ID, SUSPENSE_ALLOWED_FLAG) govern automatic account derivation.
• Standard audit columns such as LAST_UPDATE_DATE, CREATED_BY, and the ATTRIBUTE1–15 descriptive flexfield columns.

Common Use Cases and Queries

Because GL_LEDGERS sits at the heart of General Ledger, it is queried in nearly every financial reporting, diagnostic, and integration scenario. Typical patterns include resolving a ledger name from a known ID, identifying all reporting currencies tied to a primary ledger, and validating period-control configuration.

• Resolve ledger identity during journal import troubleshooting: join GL_INTERFACE or GL_JE_HEADERS on LEDGER_ID to obtain NAME, CURRENCY_CODE, and PERIOD_SET_NAME.
• List primary and secondary ledgers for a given chart of accounts using CHART_OF_ACCOUNTS_ID combined with GL_LEDGERS_N1.
• Audit accounting setup completeness by filtering COMPLETION_STATUS_CODE = 'Complete'.
• Examine ledger sets by selecting rows where OBJECT_TYPE_CODE indicates a ledger set and joining GL_LEDGER_SET_ASSIGNMENTS for member ledgers.

A representative query resolves ledger attributes from a transaction ledger identifier:

SELECT l.ledger_id, l.name, l.short_name, l.currency_code, l.period_set_name FROM gl_ledgers l WHERE l.ledger_id = :ledger_id;

Related Objects

GL_LEDGERS maintains numerous foreign key relationships, functioning as both a dependent and a referenced parent. Significant related objects include:

• GL_JE_HEADERS and GL_JE_LINES — journals reference the ledger via LEDGER_ID.
• GL_LEDGER_CONFIGURATIONS — parent of the CONFIGURATION_ID relationship, holding accounting setup definitions.
• GL_LEDGER_SET_ASSIGNMENTS — associates ledgers with their containing ledger sets through LEDGER_SET_ID and LEDGER_ID.
• GL_LEDGER_RELATIONSHIPS — defines primary, secondary, and SLA relationships among SOURCE_LEDGER_ID, TARGET_LEDGER_ID, and PRIMARY_LEDGER_ID.
• GL_CODE_COMBINATIONS — referenced by retained earnings, rounding, and net income CCID columns.
• GL_ACCESS_SETS — linked through IMPLICIT_ACCESS_SET_ID for ledger security.
• GL_INTERFACE — staging area referencing the target ledger during journal import.
• GL_DAILY_CONVERSION_TYPES and FND_CURRENCIES — supply rate types and currency definitions.

In 12.2.2, the table retains the same physical schema as 12.1.1, with the SQLGL.GL_LEDGERS FND design data record providing version-specific metadata used by the application's object library.