Search Results xla_accounting_errors

Overview

GL_LEDGERS is the ledger definition table in the Oracle General Ledger (GL) module of Oracle E-Business Suite, owned by the GL schema. In EBS 12.1.1 and 12.2.2, a "ledger" replaces the earlier concept of a "set of books" and represents the fundamental accounting container that binds together a chart of accounts, an accounting calendar, a functional currency, and a subledger accounting (SLA) method. Every journal entry, account balance, budget, and intercompany transaction in the General Ledger ultimately resolves to a row in this table through its LEDGER_ID surrogate key.

From a Data Vault modeling perspective, the heuristic classification for GL_LEDGERS is a hub. It is a master-level entity keyed by a single surrogate identifier (LEDGER_ID), and it is referenced by a large number of satellite-style and link-style tables (journal headers, journal lines, ledger relationships, ledger set assignments, and reporting tables) rather than depending on them. This makes it a natural anchor point for a dimensional or Data Vault model of GL master data.

Key Information Stored

The table contains 89 documented columns in the 12.2.2 schema. The most operationally significant are:

• LEDGER_ID — the surrogate primary key (constrained by GL_LEDGERS_PK) and the value propagated to virtually every GL and subledger table.
• NAME and SHORT_NAME — the business identifiers of the ledger; both are enforced by unique indexes (GL_LEDGERS_U1 and GL_LEDGERS_U3). LEDGER_ID itself is also unique (GL_LEDGERS_U2).
• CHART_OF_ACCOUNTS_ID — the key flexfield structure attached to the ledger's accounting flexfield.
• CURRENCY_CODE — the functional (ledger) currency, referencing FND_CURRENCIES.
• PERIOD_SET_NAME and ACCOUNTED_PERIOD_TYPE — the accounting calendar and period type governing the ledger.
• LEDGER_CATEGORY_CODE — indicates whether the ledger is a primary or secondary ledger, governing translation and reporting behavior.
• CONFIGURATION_ID — references GL_LEDGER_CONFIGURATIONS, which defines the subledger and accounting configuration attached to the ledger.
• RET_EARN_CODE_COMBINATION_ID, SUSPENSE_ALLOWED_FLAG, and related CCID columns — control retained earnings, suspense, rounding, and net income account postings.
• IMPLICIT_ACCESS_SET_ID and IMPLICIT_LEDGER_SET_ID — the access set and ledger set used for security and consolidated reporting.
• SLA_ACCOUNTING_METHOD_CODE and SLA_SEQUENCING_FLAG — Subledger Accounting method and journal sequencing configuration.
• COMPLETION_STATUS_CODE and COMPLETE_FLAG — indicate whether ledger setup is finalized and usable.

Common Use Cases and Queries

The most frequent query pattern resolves the current ledger context from the session or from a known SET_OF_BOOKS_ID / LEDGER_ID value. A typical reporting query joins GL_LEDGERS to FND_CURRENCIES to confirm functional currency and to GL_JE_HEADERS to aggregate journal activity:

• Identifying the primary ledger and its currency for a given operating unit or responsibility.
• Listing secondary ledgers and their translation rate types (PERIOD_AVERAGE_RATE_TYPE, PERIOD_END_RATE_TYPE) for consolidation reporting.
• Detecting incomplete ledger setup by filtering on COMPLETION_STATUS_CODE.
• Driving RG_REPORT_CONTENT_OVERRIDES, RG_REPORT_REQUESTS, and RG_REPORT_AXIS_CONTENTS reporting by LEDGER_ID, which is the exact context in which the reported search term appears — these tables all carry an LEDGER_ID foreign key back to GL_LEDGERS.

A representative join is:

SELECT gl.ledger_id, gl.name, gl.currency_code, gl.period_set_name
FROM gl_ledgers gl
WHERE gl.completion_status_code = 'C'
AND gl.ledger_category_code = 'P';

Related Objects

GL_LEDGERS is referenced by a broad set of downstream tables. The most significant, based on the documented foreign key relationships, include:

• GL_JE_HEADERS and GL_JE_LINES — journal entry headers and lines, joined on LEDGER_ID; the primary transaction activity for each ledger.
• GL_INTERFACE and GL_INTERFACE_CONTROL — inbound journal import staging, referencing LEDGER_ID and SET_OF_BOOKS_ID.
• GL_LEDGER_RELATIONSHIPS — defines primary-to-secondary and SLA ledger mappings, referencing SOURCE_LEDGER_ID, TARGET_LEDGER_ID, PRIMARY_LEDGER_ID, and SLA_LEDGER_ID.
• GL_LEDGER_SET_ASSIGNMENTS and GL_LEDGER_SET_REQUESTS — assign ledgers to ledger sets used for consolidated reporting.
• GL_INTERCOMPANY_ACCOUNTS and GL_INTERCOMPANY_ACC_SETS — intercompany balancing configuration keyed by LEDGER_ID.
• RG_REPORT_CONTENT_OVERRIDES, RG_REPORT_REQUESTS, and RG_REPORT_AXIS_CONTENTS — Financial Statement Generator (FSG) reporting objects that override or request content per ledger; these tables link to GL_LEDGERS on LEDGER_ID and are the direct context of the user's search.
• GL_LEDGER_NORM_SEG_VALS and GL_LEDGER_SEGMENT_VALUES — normal and assigned segment value definitions scoped to a ledger.