Search Results gl_xfr_ledger_mappings_u2

Overview

GL.GL_XFR_LEDGER_MAPPINGS is a General Ledger configuration table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the cross-references between E-Business Suite (EBS) ledgers and their corresponding Fusion General Ledger ledgers. It is a control table supporting the ledger-level data transformation required when EBS subledger and GL balances are migrated or interfaced to a Fusion environment. Each row defines one mapping between a source EBS ledger, identified by its ledger identifier and functional currency, and a target Fusion ledger, along with pointers to the chart of accounts and calendar mappings that translate accounting flexfield and period structures across the two systems.

From a heuristic Data Vault modeling perspective, this object is classified as satellite-leaning. It behaves as a descriptive container attached to a ledger identity, holding attributes (currency, COA mapping, calendar mapping, run tracking) that describe the relationship rather than defining a pure hub or link entity. The table resides in the APPS_TS_TX_DATA tablespace with 10 percent PCTFREE and is registered under the FND design data object SQLGL.GL_XFR_LEDGER_MAPPINGS.

Key Information Stored

The surrogate primary key of the table is LEDGER_MAPPING_ID, a NUMBER(15) entity identifier. Two unique indexes exist as business-key candidates: GL_XFR_LEDGER_MAPPINGS_U1 enforces uniqueness on LEDGER_MAPPING_ID, while GL_XFR_LEDGER_MAPPINGS_U2 enforces uniqueness on the combination of FROM_LEDGER_ID and FROM_LEDGER_CURRENCY, effectively guaranteeing that any given source ledger and currency pair maps to only one deployment mapping record.

• LEDGER_MAPPING_ID – Surrogate entity identifier and primary key.
• FROM_LEDGER_ID – Identifier of the source EBS ledger.
• FROM_LEDGER_CURRENCY – Currency code of the EBS ledger, forming the second part of the U2 business key.
• TO_LEDGER_ID – Identifier of the target Fusion ledger (indexed non-uniquely via GL_XFR_LEDGER_MAPPINGS_N1).
• COA_MAPPING_ID – Identifier of the chart of accounts mapping used to translate accounting flexfield segments.
• CALENDAR_MAPPING_ID – Pointer to the corresponding row in GL_XFR_CALENDAR_MAPPINGS for period/calendar translation.
• MAX_DELTA_RUN_ID – Tracks the maximum delta run identifier processed for incremental transfers.
• FIRST_EFF_PER_NUM – The earliest effective period ever transferred for this mapping.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN – Standard WHO audit columns.

Common Use Cases and Queries

Typical usage centers on configuration auditing, migration status checks, and join-driven reporting. Administrators query this table to verify which EBS ledgers are mapped to which Fusion ledgers, and to confirm the COA and calendar mapping pairings before running a transfer or delta load. Because MAX_DELTA_RUN_ID and FIRST_EFF_PER_NUM track transfer progress, operational queries frequently extract them to determine the last successfully processed run and the earliest period covered.

SELECT m.FROM_LEDGER_ID, m.FROM_LEDGER_CURRENCY, m.TO_LEDGER_ID,
       m.COA_MAPPING_ID, m.CALENDAR_MAPPING_ID,
       m.MAX_DELTA_RUN_ID, m.FIRST_EFF_PER_NUM
FROM   GL.GL_XFR_LEDGER_MAPPINGS m
WHERE  m.FROM_LEDGER_CURRENCY = :currency;

The U2 constraint makes lookups by the FROM_LEDGER_ID and FROM_LEDGER_CURRENCY pair highly efficient. A complementary pattern joins GL_XFR_CCID_MAPPINGS back to this table on LEDGER_MAPPING_ID to reconcile code combination level mappings for a given ledger pair.

Related Objects

• GL.GL_LEDGERS – Parent of the FROM_LEDGER_ID foreign key.
• FND_CURRENCIES – Source of the FROM_LEDGER_CURRENCY foreign key.
• GL.GL_COA_MAPPINGS – Referenced by COA_MAPPING_ID for accounting flexfield translation.
• GL_XFR_CALENDAR_MAPPINGS – Referenced indirectly by CALENDAR_MAPPING_ID for period mapping.
• GL.GL_XFR_CCID_MAPPINGS – Child table referencing LEDGER_MAPPING_ID; carries code combination level mappings.