Results for “wip_variance”
44 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
MTL_PAC_TXN_COST_DETAILS is an Inventory (INV) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the transaction-level cost detail rows generated for a given periodic costing period. Its documented description is simply "Transaction details for a period," which reflects its purpose: it is the granularization layer beneath the periodic average cost (PAC) engine, holding the exploded cost information for each material transaction, item, cost group, cost element, and cost type within a defined PAC period. The table is owned by the INV schema and is classified as VALID in the ETRM dictionary.
Because the table's primary key is a composite of foreign key references rather than an independent surrogate, the heuristic Data Vault classification derived from the FK structure is link. In a Data Vault model, this table functions as a transactional link table connecting material transactions, inventory items, cost groups, cost types, cost elements, and PAC periods.
Key Information Stored
The 21 documented columns encode both the composite key and the computed cost measures. The most important columns are:
- TRANSACTION_ID – Reference to the originating material transaction in MTL_MATERIAL_TRANSACTIONS.
- INVENTORY_ITEM_ID – The item whose cost is being detailed.
- COST_GROUP_ID – The cost group to which the transaction is assigned.
- COST_TYPE_ID – The cost type context (e.g., frozen, average) for the detail row.
- COST_ELEMENT_ID – The cost element (material, overhead, resource, etc.) being broken out.
- PAC_PERIOD_ID – The periodic costing period within which the transaction is processed.
- LEVEL_TYPE – Distinguishes the level of the cost roll-up (e.g., item, cost group).
- TRANSACTION_COST – The cost amount attributable to this detail row.
- NEW_PERIODIC_COST – The recomputed periodic cost after the transaction is applied.
- PERCENTAGE_CHANGE / VALUE_CHANGE – The delta versus the prior period, supporting variance analysis.
- WIP_VARIANCE – The work-in-process variance associated with the transaction.
- REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – WHO/When audit and concurrent request provenance columns.
Surrogate vs. business key: The primary key constraint MTL_PAC_TXN_COST_DETAILS_PK is defined over (TRANSACTION_ID, INVENTORY_ITEM_ID, COST_GROUP_ID, LEVEL_TYPE, COST_TYPE_ID, PAC_PERIOD_ID, COST_ELEMENT_ID). A separate unique index, MTL_PAC_TXN_COST_DETAILS_U1, offers an alternate business-key candidate on (TRANSACTION_ID, PAC_PERIOD_ID, COST_GROUP_ID, COST_ELEMENT_ID, LEVEL_TYPE) — the difference being that U1 does not include INVENTORY_ITEM_ID or COST_TYPE_ID, indicating the natural granularity of a PAC transaction detail line.
Common Use Cases and Queries
Typical uses include periodic costing reconciliation, cost element variance reporting, and audit of PAC runs. Analysts query this table to trace how a specific material transaction contributed to a period's periodic average cost, or to aggregate cost by element across a period.
SELECT t.TRANSACTION_ID,
t.INVENTORY_ITEM_ID,
t.COST_ELEMENT_ID,
t.TRANSACTION_COST,
t.NEW_PERIODIC_COST,
t.VALUE_CHANGE
FROM MTL_PAC_TXN_COST_DETAILS t
WHERE t.PAC_PERIOD_ID = :pac_period_id
AND t.COST_GROUP_ID = :cost_group_id;
Joining to MTL_MATERIAL_TRANSACTIONS yields the transaction date, transaction type, and quantity for a full cost-flow picture, while joining to CST_COST_ELEMENTS gives the element name for readable variance reports.
Related Objects
The foreign key relationships documented in the ETRM establish the following dependencies:
- MTL_MATERIAL_TRANSACTIONS – joined on TRANSACTION_ID (source transaction).
- CST_PAC_PERIODS – joined on PAC_PERIOD_ID (periodic costing period definition).
- CST_COST_GROUPS – joined on COST_GROUP_ID.
- CST_COST_TYPES – joined on COST_TYPE_ID.
- CST_COST_ELEMENTS – joined on COST_ELEMENT_ID.
These five parent tables supply every dimension of the composite key. Downstream reporting views and concurrent programs in the Cost Management module reference this table when summarizing periodic cost and variance results.
-
Transaction details for a period
-
Used to temporarily hold data during the interorg iteration process
-
Stores the elemental cost for a given transaction in a period
-
Used to temporarily hold data during the interorg iteration process
-
Transaction details for a period
-
Stores the elemental cost for a given transaction in a period
-
APPS.CSTPPWAS SQL Statements 12.2.2
-
APPS.CSTPPWAS SQL Statements 12.1.1
-
PACKAGE BODY: APPS.CSTPPWAS 12.2.2
-
PACKAGE BODY: APPS.CSTPPWAS 12.1.1
-
PACKAGE BODY: APPS.CSTPAPBR 12.1.1
-
PACKAGE BODY: APPS.CSTPAPBR 12.2.2
-
APPS.CSTPPWAC SQL Statements 12.2.2
-
APPS.CSTPAPBR SQL Statements 12.1.1
-
APPS.CSTPPWAC SQL Statements 12.1.1
-
APPS.CSTPAPBR SQL Statements 12.2.2
-
PACKAGE BODY: APPS.CSTPPWAC 12.1.1
-
PACKAGE BODY: APPS.CSTPPWAC 12.2.2
-
eTRM - INV Tables and Views 12.1.1
-
eTRM - INV Tables and Views 12.2.2