Results for “mtl_txn_cost_det_interface”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The MTL_TXN_COST_DET_INTERFACE table resides in the INV (Inventory) schema and is a key component of the Oracle E-Business Suite transaction interface framework. Its documented purpose is to store transaction cost by cost element and by level for transactions that are scheduled to be imported through the transaction interface. In practice, this table acts as a staging area where cost detail rows are written—typically by the Cost Management (CST) module or by external feeder systems—prior to validation and transfer into the permanent cost tables.
Each row represents a single cost component (element) associated with a single inventory transaction interface record. The table is populated with granular cost breakdowns, including the resulting average cost and the percentage or value change that the transaction causes. Because the transaction interface processes large volumes of transactions in batch, this table effectively bridges the staging layer (MTL_TRANSACTIONS_INTERFACE) and the finalized cost layer.
From a Data Vault modeling perspective, the metadata classifies this object as satellite-leaning. This heuristic suggests that the table should be modeled as a satellite attached to a hub or link representing the transaction interface event, with the cost element attributes describing the context of each cost detail row rather than functioning as a standalone business entity.
Key Information Stored
The table contains 23 documented columns. The following are the most significant:
- TRANSACTION_INTERFACE_ID – The surrogate/business identifier linking each cost detail row to its parent transaction interface record. This is the primary join key to the transaction interface header.
- COST_ELEMENT_ID and COST_ELEMENT – Identify the cost element (e.g., material, overhead, resource) that the cost amount belongs to. COST_ELEMENT_ID carries a documented foreign key to CST_COST_ELEMENTS.
- LEVEL_TYPE and LEVEL_NAME – Define the costing level at which the cost is expressed.
- TRANSACTION_COST – The cost value attributable to this element and level for the transaction.
- NEW_AVERAGE_COST – The recalculated average cost resulting from the transaction.
- PERCENTAGE_CHANGE and VALUE_CHANGE – The relative and absolute change in cost caused by the transaction, useful for cost-impact analysis.
- ORGANIZATION_ID, ORGANIZATION_NAME, and ORGANIZATION_CODE – Identify the inventory organization context, allowing multi-org reporting without additional joins.
- ERROR_CODE and ERROR_EXPLANATION – Capture validation failures encountered during interface processing.
- REQUEST_ID, PROGRAM_ID, and PROGRAM_APPLICATION_ID – Concurrency audit columns identifying the batch that populated the row.
- Standard WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) provide audit tracking.
Common Use Cases and Queries
Typical uses include diagnosing interface failures, validating cost impacts before posting, and reconciling staged costs against final inventory valuations.
- Identifying rows with validation errors:
SELECT TRANSACTION_INTERFACE_ID, COST_ELEMENT, ERROR_CODE, ERROR_EXPLANATION FROM MTL_TXN_COST_DET_INTERFACE WHERE ERROR_CODE IS NOT NULL; - Reviewing cost impact per element for a transaction:
SELECT COST_ELEMENT, TRANSACTION_COST, NEW_AVERAGE_COST, PERCENTAGE_CHANGE FROM MTL_TXN_COST_DET_INTERFACE WHERE TRANSACTION_INTERFACE_ID = :id; - Batch-level reconciliation by request: join on REQUEST_ID to trace costs back to the concurrent program that generated them.
- Organization-level cost reporting using ORGANIZATION_ID alongside cost element aggregation.
Related Objects
- MTL_TRANSACTIONS_INTERFACE – The parent staging table; joined via TRANSACTION_INTERFACE_ID.
- CST_COST_ELEMENTS – Referenced by the documented foreign key COST_ELEMENT_ID; supplies cost element names and types.
- CST_TRANSACTION_COSTS – The final cost table populated after successful interface processing.
- MTL_SYSTEM_ITEMS_B – Provides item context for related interface rows.
- ORG_ORGANIZATION_DEFINITIONS – Resolves organization identifiers used in this table.
- MTL_TRANSACTION_INTERFACE_PUB / MTL_TXN_PROCESSOR – APIs and processors that read this table during import and cost transfer.
-
Stores transaction cost by element and by level for transactions to be imported through the transaction interface
-
Stores transaction cost by element and by level for transactions to be imported through the transaction interface
-
PACKAGE BODY: APPS.CSTPACIT 12.1.1
-
PACKAGE: APPS.CSTPACIT 12.2.2
-
PACKAGE: APPS.CSTPACIT 12.1.1
-
PACKAGE BODY: APPS.CSTPACIT 12.2.2
-
APPS.CSTPACIT SQL Statements 12.1.1
-
APPS.CSTPACIT SQL Statements 12.2.2
-
PACKAGE BODY: APPS.CSTPACIT 12.1.1
-
PACKAGE: APPS.CSTPPCIT 12.2.2
-
PACKAGE BODY: APPS.CSTPPCIT 12.2.2
-
PACKAGE BODY: APPS.CSTPPCIT 12.1.1
-
PACKAGE: APPS.CSTPPCIT 12.1.1
-
PACKAGE BODY: APPS.CSTPACIT 12.2.2
-
APPS.CSTPPCIT SQL Statements 12.1.1
-
APPS.CSTPPCIT SQL Statements 12.2.2
-
View: CST_AP_VARIANCE_V 12.2.2
APPS.CST_AP_VARIANCE_V·↳ AP_INVOICES_ALL·↳ CST_AP_VARIANCE_BATCHES·↳ CST_AP_VARIANCE_HEADERS·Explore BOM module →
-
View: CST_AP_VARIANCE_V 12.1.1
APPS.CST_AP_VARIANCE_V·↳ AP_INVOICES_ALL·↳ CST_AP_VARIANCE_BATCHES·↳ CST_AP_VARIANCE_HEADERS·Explore BOM module →
-
Table: JAI_MTL_TXN_CST_DTL_T 12.2.2
Replica for the Data inserted by IL into the MTL_TXN_COST_DET_INTERFACE
-
Table: JAI_MTL_TXN_CST_DTL_T 12.1.1
Replica for the Data inserted by IL into the MTL_TXN_COST_DET_INTERFACE
-
VIEW: APPS.CST_AP_VARIANCE_V 12.2.2
-
VIEW: APPS.CST_AP_VARIANCE_V 12.1.1
-
VIEW: APPS.CST_AP_VARIANCE_V 12.1.1