Results for “gl_xfr_ledger_mappings_pk”

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

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:

• LEDGER_MAPPING_ID — the surrogate primary key, defined by GL_XFR_LEDGER_MAPPINGS_PK. It uniquely identifies each ledger mapping record and is the value referenced by child tables.
• FROM_LEDGER_ID — the source EBS ledger, referencing GL_LEDGERS. This is one half of the designated unique business-key candidate.
• FROM_LEDGER_CURRENCY — the functional currency of the source ledger, referencing FND_CURRENCIES. Together with FROM_LEDGER_ID it forms the unique index GL_XFR_LEDGER_MAPPINGS_U2 (FROM_LEDGER_ID, FROM_LEDGER_CURRENCY), which is the strongest business-key candidate on the table.
• TO_LEDGER_ID — the target Fusion ledger to which the source ledger is mapped.
• COA_MAPPING_ID — the Chart of Accounts mapping definition that governs how EBS account combinations translate to their Fusion equivalents, referencing GL_COA_MAPPINGS.
• CALENDAR_MAPPING_ID — the mapping that aligns the EBS accounting calendar with the Fusion calendar.
• MAX_DELTA_RUN_ID — tracks the highest processing run identifier, used to support incremental (delta) transfer of data since the last execution.
• FIRST_EFF_PER_NUM — the first effective period number, anchoring the mapping to a point in the accounting calendar.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard EBS audit columns recording who created and last modified each mapping and when.

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.