Search Results mtl_consumption_transactions




Overview
Explore in AI Chat

Overview

MTL_CONSUMPTION_TRANSACTIONS is an Inventory (INV) module table in Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It records information about change-of-ownership transactions affecting consigned inventory, and it is populated and consumed by the "Create Consumption Advice" concurrent program. In a consignment arrangement, the supplier retains title to goods held at the buyer's site until the buyer consumes them; this table captures the consumption events that convert consigned stock into owned inventory and drive the resulting payables activity.

The documented schema, owner INV, contains 40 columns with a primary key on TRANSACTION_ID. The ETRM data vault classification is heuristic and mined from FK structure, yielding a "standalone" classification. Interpreted as a modeling suggestion, this indicates the table is not a strict hub-and-link construct but rather behaves as a central transaction or detail entity with no enforced foreign-key dependencies radiating from it. It therefore functions closest to a satellite-style transactional fact record keyed by its own surrogate identifier.

Key Information Stored

TRANSACTION_ID is the documented primary key and surrogate identifier for each consumption transaction row. The table does not expose an additional documented unique business key, so the surrogate distinguishes records while the following columns carry the substantive business content:

Common Use Cases and Queries

Typical uses include reconciling consigned consumption against purchase orders, tracing failed consumption advice processing, and producing audit reports on change-of-ownership activity. A common reporting query filters by processing status:

  • SELECT transaction_id, inventory_item_id, organization_id, net_qty, transaction_date, consumption_processed_flag FROM mtl_consumption_transactions WHERE consumption_processed_flag = 'N';
  • Joining to PO distributions via PO_DISTRIBUTION_ID or INTERFACE_DISTRIBUTION_REF to reconcile consumed quantities with received and invoiced amounts.
  • Filtering by REQUEST_ID or BATCH_ID to isolate rows produced by a specific "Create Consumption Advice" run.
  • Selecting ERROR_CODE and ERROR_EXPLANATION where processing has failed, to troubleshoot tax or accounting rejections.
  • Aggregating NET_QTY by INVENTORY_ITEM_ID and OWNING_ORGANIZATION_ID for consignment liability reporting.

Related Objects

Because the heuristic classification is standalone, relationships are primarily functional rather than enforced by foreign keys. Principal related objects include:

The "Create Consumption Advice" concurrent program is the primary process that both populates and consumes this table, making its request and batch context integral to any investigative or reconciliation query.