Search Results consumption_txn_manager




Overview
Explore in AI Chat

Overview

INV_THIRD_PARTY_STOCK_CP is an Oracle EBS inventory package body owned by APPS and classified under the ETRM metadata as OTHER. The source header (INVCCCPB.pls) identifies it as the "Consigned Inventory Consumption Concurrent Program Wrapper." Its role is to serve as the executable PL/SQL layer that drives the consumption of consigned (third-party owned) inventory. Consigned inventory is material held at a warehouse but still owned by a supplier until it is actually consumed; this package handles the transactional recognition of that consumption event within Oracle Inventory.

The package follows the standard Oracle EBS concurrent program wrapper pattern: it validates and forwards parameters, delegates substantive work to a private API (.PVT) layer, and returns a retcode and error buffer to the concurrent manager. The header dates the initial creation to 2002, and it forms part of the consigned inventory feature set introduced in that release line.

Key Procedures and Functions

  • cons_txn_work — A private procedure that performs the batch-level work for consumption processing. According to the source comments, it copies all records belonging to a context batch from MTL_CONSUMPTION_TRANSACTIONS into MTL_CONSUMPTION_TRANSACTIONS_TEMP, summarizes the net quantity for the batch, and then calls the "create consumption advice" procedure. It accepts a batch identifier and returns a retcode and error buffer. In the version shown, the body delegates to INV_THIRD_PARTY_STOCK_CAD_PVT.cons_txn_work, passing the retcode and batch ID, so the actual logic resides in the companion private package.
  • consumption_txn_manager — The documented entry point associated with the user's search term. As its name indicates, it acts as the manager/orchestrator for consumption transactions, coordinating the invocation of the worker routine above. The procedure list in the package header names it alongside cons_txn_work as one of the two public procedures.

Tables Accessed

The source comment documents two Inventory tables as central to processing:

  • MTL_CONSUMPTION_TRANSACTIONS — the source staging table holding consumption transaction records for a context batch. The procedure reads all records for the given batch from this table.
  • MTL_CONSUMPTION_TRANSACTIONS_TEMP — a temporary working table to which those records are copied, enabling net-quantity summarization prior to advice creation.

The ETRM metadata records no additional table references via APPS synonyms, and the package is referenced by zero other packages, indicating it is invoked directly rather than called programmatically from other PL/SQL units.

Usage Notes

Because this is a concurrent program wrapper, it is typically invoked by the Oracle Concurrent Manager as the executable logic behind the Consigned Inventory Consumption concurrent program, rather than from an Oracle Forms screen or custom API call. The concurrent manager supplies the batch context, and the wrapper returns a standard success/failure retcode and error message.

In releases 12.1.1 and 12.2.2, the object remains an APPS-owned inventory wrapper; the underlying consumption logic is maintained in the INV_THIRD_PARTY_STOCK_CAD_PVT private package. Customizations should avoid modifying this wrapper directly and instead target the private API layer or extend behavior through supported hooks.