Search Results mtl_txn_cost_det_interface




Overview
Explore in AI Chat

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:

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.