Search Results mtl_movement_statistics_efc

Overview

MTL_MOVEMENT_STATISTICS_EFC is an Inventory (INV) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that serves as the Euro-as-a-Functional-Currency archive for movement statistics records. The "_EFC" suffix denotes "Euro Functional Currency," identifying this as a supplementary archive created to preserve movement statistics transactions after a set of books transitioned to the Euro as its functional currency. The table is owned by the INV schema and is documented as VALID.

The table records only three columns: CURRENCY_CONVERSION_RATE, MOVEMENT_ID, and SET_OF_BOOKS_ID. This narrow footprint confirms its archival purpose: it stores the conversion rate applied to each archived movement record and links back to the originating movement statistics row through MOVEMENT_ID. Because the table carries only rate and key data, it functions as an extension of the parent statistics record rather than a standalone transactional entity.

The heuristic Data Vault classification mined from the foreign key structure is standalone. In Data Vault modeling terms, this object does not behave as a hub, link, or satellite in isolation; instead it should be modeled as a satellite or descriptive extension attached to the MTL_MOVEMENT_STATISTICS hub, keyed by MOVEMENT_ID and qualified by SET_OF_BOOKS_ID. Its single-column foreign key relationship to MTL_MOVEMENT_STATISTICS confirms this dependent relationship.

Key Information Stored

The documented physical schema for 12.2.2 contains exactly three columns:

• CURRENCY_CONVERSION_RATE — The exchange rate used to convert the movement statistics amount into the Euro functional currency at the time the archive record was created. This is the core business value of the table.
• MOVEMENT_ID — The identifier of the associated movement statistics transaction. This is a foreign key referencing MTL_MOVEMENT_STATISTICS.MOVEMENT_ID and serves as the primary business-key candidate joining archived EFC data back to source records.
• SET_OF_BOOKS_ID — The set of books (ledger) under which the movement was booked. This distinguishes archival rows across multiple accounting representations, since a given movement may be archived under more than one set of books.

No surrogate primary key column is documented in the metadata excerpt, and no unique index is enumerated. The effective uniqueness of a row is therefore governed by the combination of MOVEMENT_ID and SET_OF_BOOKS_ID. Practitioners should treat this composite as the natural key when reconciling or de-duplicating archive contents.

Common Use Cases and Queries

Typical use cases center on audit, reporting, and migration validation following a Euro conversion.

• Audit of conversion rates applied to movement statistics: Retrieve the rate stored for each archived movement to verify Euro conversion accuracy.
• Reconciliation with the parent table: Join the archive back to MTL_MOVEMENT_STATISTICS to confirm every movement has a corresponding rate record.
• Multi-ledger reporting: Filter by SET_OF_BOOKS_ID to report on Euro-converted movement statistics for a specific ledger.
• Data migration validation: Compare archived rates against externally maintained rate tables when upgrading from 12.1.1 to 12.2.2.

A representative query joining the archive to its source:

SELECT mms.MOVEMENT_ID, mms.SET_OF_BOOKS_ID, efc.CURRENCY_CONVERSION_RATE
FROM INV.MTL_MOVEMENT_STATISTICS mms, INV.MTL_MOVEMENT_STATISTICS_EFC efc
WHERE mms.MOVEMENT_ID = efc.MOVEMENT_ID
AND mms.SET_OF_BOOKS_ID = efc.SET_OF_BOOKS_ID;

Related Objects

The table has a narrow dependency footprint, with one documented foreign key relationship:

• MTL_MOVEMENT_STATISTICS — The parent table; joined on MOVEMENT_ID. This is the primary object referenced by the archive and the principal source of related transactional detail.

Beyond the documented FK, the following objects are commonly associated with movement statistics processing and are relevant when interpreting this archive: MTL_MATERIAL_TRANSACTIONS (the underlying transaction source), MTL_TRANSACTION_TYPES, MTL_PARAMETERS, and GL_SETS_OF_BOOKS / FND_CURRENCIES (for functional currency context). Because the metadata classifies this object as standalone and documents only a single FK, the archive should be treated as a tightly scoped supplement to MTL_MOVEMENT_STATISTICS rather than a hub in its own right.