Search Results mtl_consumption_transactions_temp




Overview
Explore in AI Chat

Overview

APPS.INV_CONSUMPTION_ADVICE_CP is a concurrent program wrapper package belonging to the Oracle Inventory (INV) module, introduced in Release 11i and carried forward unchanged into Oracle E-Business Suite 12.1.1 and 12.2.2. Its name — "Consumption Advice Concurrent Program" — reflects its narrow but essential role within the Consigned Inventory feature set: it drives the batch processing of consigned inventory consumption transactions and the subsequent generation of consumption advice records against the supplier.

The package header, as documented in the ETRM repository, identifies it explicitly as the "Consigned Inventory Consumption Concurrent Program Wrapper." It is classified as an OTHER API, meaning it is not published as a public integration interface but rather as an internal engine called by the concurrent manager. The body was authored in 2002 (INVCCADB.pls, version 115.1) and the two procedures it exposes — CONSUMPTION_TXN_MANAGER and CONSUMPTION_TXN_WORKER — form a classic manager/worker concurrency pattern. The package contains no business logic of its own; it delegates all substantive processing to INV_CONSUMPTION_ADVICE_PROC and simply translates unhandled exceptions into a concurrent program return code and error buffer.

Key Procedures and Functions

  • CONSUMPTION_TXN_MANAGER — The public entry point invoked by the concurrent manager. Its documented purpose is to scan unprocessed rows in MTL_CONSUMPTION_TRANSACTIONS, assign each qualifying record to a processing batch, and then invoke CONSUMPTION_TXN_WORKER for that batch. The manager loops over batches until all eligible records have been consumed, providing the commit boundary and restartability expected of a concurrent request.
  • CONSUMPTION_TXN_WORKER — The private worker procedure. Per the embedded comments, it copies all records belonging to a context batch from MTL_CONSUMPTION_TRANSACTIONS to MTL_CONSUMPTION_TRANSACTIONS_TEMP, summarizes the net quantity, and calls the create consumption advice procedure. It accepts a batch identifier together with OUT NOCOPY return code and error buffer parameters, and traps WHEN OTHERS by setting the return code to 2 and populating the error buffer from FND_MSG_PUB.Get, truncated to 250 bytes.

Tables Accessed

The documented body references two application tables, accessed through APPS synonyms:

  • MTL_CONSUMPTION_TRANSACTIONS — The staging table holding raw consigned consumption events awaiting batching. The manager reads unprocessed rows here and assigns batch identifiers.
  • MTL_CONSUMPTION_TRANSACTIONS_TEMP — The working table for a single batch. The worker copies the batch's rows into this temporary structure, sums net quantities by item and supplier context, and passes the summarized result to INV_CONSUMPTION_ADVICE_PROC for advice creation.

This two-table staging pattern isolates summarization from the source data, allowing the advice-creation procedure to operate on a clean, aggregated batch.

Usage Notes

INV_CONSUMPTION_ADVICE_CP is not intended for direct invocation from forms or custom PL/SQL. It is registered as a concurrent program in Oracle Inventory and is submitted either on demand or on a schedule by the Consigned Inventory consumption workflow. In 12.1.1 and 12.2.2 the package remains an APPS-owned, wrapped object; the ETRM metadata records no other packages that reference it, confirming it is a top-level entry point rather than a shared library. Because the error handling is generic, diagnostics should be read from the concurrent request log populated via FND_MSG_PUB rather than from the return code alone.