Results for “compile_id”

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

Overview

MTL_ABC_COMPILE_HEADERS_EFC is an Oracle Inventory (INV) archive table that stores historical ABC compile header information captured during the transition of a ledger to the Euro as its functional currency. The suffix _EFC denotes "Euro as a Functional Currency," and tables bearing this suffix were introduced to preserve pre-conversion balances when the functional currency of a set of books changed. In Oracle EBS 12.1.1 and 12.2.2, this table exists in the INV schema with a status of VALID and is classified as a standalone object.

ABC compiles drive the cycle count and inventory classification process, assigning A, B, or C rankings to items based on cumulative value. When the functional currency conversion occurs, the compile header values denominated in the original currency must be retained for audit and reconciliation, and MTL_ABC_COMPILE_HEADERS_EFC serves exactly that purpose. Under a heuristic Data Vault classification, the object behaves as a satellite attached to the ABC compile business key, because it records descriptive, time-bound measures (the cumulative value) associated with a compile rather than defining a new entity or a pure many-to-many relationship.

Key Information Stored

The documented physical schema comprises three columns, each of which carries critical meaning:

• COMPILE_ID — The foreign key that links each archive row back to the corresponding parent row in MTL_ABC_COMPILE_HEADERS. This is the primary business-key candidate and the join column that gives the archive its context.
• SET_OF_BOOKS_ID — Identifies the ledger (formerly set of books) for which the ABC compile was executed and subsequently archived. Because the Euro conversion is ledger-specific, this column scopes the archived data to the correct accounting entity.
• CUMULATIVE_VALUE — Holds the cumulative inventory value computed during the ABC compile, expressed in the pre-conversion functional currency. This is the measure that preserves the historical monetary position.

The foreign key relationship on COMPILE_ID pointing to MTL_ABC_COMPILE_HEADERS is the only documented referential constraint, confirming the parent-child nature of the archive. No separate surrogate primary key column is enumerated in the documented metadata; the identifying lineage is inherited from the parent compile header.

Common Use Cases and Queries

Typical uses center on auditing and reconciliation of ABC classification results across a currency conversion. Analysts join the archive to its parent to compare pre- and post-conversion cumulative values:

• Reconciling historical ABC compile results against current headers to validate conversion accuracy.
• Reporting cumulative inventory value by ledger for periods preceding the functional currency change.
• Audit support when external auditors request evidence of ABC compile history retained through a Euro conversion.

A representative query pattern joins the two objects on COMPILE_ID:

SELECT h.compile_id, h.set_of_books_id, e.cumulative_value
FROM   mtl_abc_compile_headers h,
       mtl_abc_compile_headers_efc e
WHERE  h.compile_id = e.compile_id
AND    e.set_of_books_id = :ledger_id;

Because the archive is dated and static, no DML is normally performed against it outside of Oracle-supplied conversion programs.

Related Objects

The most significant related objects, anchored on the documented foreign key, include:

• MTL_ABC_COMPILE_HEADERS — The parent header table; joined on COMPILE_ID and the principal dependency.
• MTL_ABC_COMPILE_DETAILS — Compile line detail, related through the compile header lineage.
• MTL_ABC_COMPILE_ITEMS — Item-level ABC classification output tied to a compile.
• MTL_ABC_CLASSES — Defines the A/B/C class definitions applied during a compile.
• MTL_SYSTEM_ITEMS_B — Provides item master context for classified items.
• GL_SETS_OF_BOOKS — Supplies the ledger definition referenced by SET_OF_BOOKS_ID.

These objects collectively support the end-to-end ABC compile and Euro conversion archival process.