Search Results gl_xfr_ledger_mappings




Overview
Explore in AI Chat

Overview

GL_XFR_LEDGER_MAPPINGS is a General Ledger configuration table in the GL schema that stores ledger-level mappings between an Oracle E-Business Suite source ledger and a corresponding Fusion (Oracle Cloud) target ledger. Its primary function is to support the migration and coexistence infrastructure that connects an EBS General Ledger installation with a Fusion General Ledger environment, ensuring that transactions and balances originating in EBS are correctly translated into the equivalent Fusion ledger structure.

Each row establishes the correspondence between a source (EBS) ledger, its functional currency, the target (Fusion) ledger, and the Chart of Accounts and calendar mapping definitions required to align the two systems. The table therefore acts as a controlling reference point for downstream mapping activities, most notably at the Chart of Accounts combination (CCID) level.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign-key structure is satellite-leaning. This suggests the object behaves primarily as a descriptive, attribute-bearing structure keyed against a ledger-hub concept, rather than as an independent hub or a pure many-to-many link.

Key Information Stored

The table contains 13 documented columns. The most significant are:

The unique index GL_XFR_LEDGER_MAPPINGS_U1 on LEDGER_MAPPING_ID simply reinforces the surrogate primary key. The business-meaningful uniqueness is enforced by U2.

Common Use Cases and Queries

Typical usage centers on validating and reporting the ledger alignment between EBS and Fusion. A common query resolves a source ledger to its target and associated mappings:

  • Retrieving the target ledger for a given source ledger and currency: SELECT TO_LEDGER_ID, COA_MAPPING_ID, CALENDAR_MAPPING_ID FROM GL_XFR_LEDGER_MAPPINGS WHERE FROM_LEDGER_ID = :ledger_id AND FROM_LEDGER_CURRENCY = :currency;
  • Joining to GL_LEDGERS to obtain ledger names: ... FROM GL_XFR_LEDGER_MAPPINGS m, GL_LEDGERS l WHERE m.FROM_LEDGER_ID = l.LEDGER_ID;
  • Confirming complete mapping coverage before initiating a transfer run, ensuring COA_MAPPING_ID and CALENDAR_MAPPING_ID are populated for every source ledger.
  • Monitoring incremental progress by inspecting MAX_DELTA_RUN_ID against the last processed run.
  • Auditing changes to mappings using the CREATED_BY / LAST_UPDATED_BY columns.

Because the mapping carries currency and effective-period attributes, it is also used in reconciliation reports that compare EBS balances to Fusion balances for a defined period.

Related Objects

The following objects are the most significant dependents and references for this table:

  • GL_LEDGERS — referenced via FROM_LEDGER_ID; supplies the source ledger definition.
  • FND_CURRENCIES — referenced via FROM_LEDGER_CURRENCY; provides currency validation.
  • GL_COA_MAPPINGS — referenced via COA_MAPPING_ID; defines account combination translation rules.
  • GL_XFR_CCID_MAPPINGS — the principal child table; its LEDGER_MAPPING_ID column references this table, carrying the CCID-level detail that depends on the ledger mapping header.
  • GL_XFR_LEDGER_MAPPINGS_PK / _U1 / _U2 — the primary key and unique constraints enforcing record identity and business uniqueness.

This table forms the header layer of the EBS-to-Fusion transformation configuration, with GL_XFR_CCID_MAPPINGS providing the detail rows that rely on it.