Search Results inv_consumption_advice_proc




Overview
Explore in AI Chat

Overview

The APPS.INV_CONSUMPTION_ADVICE_PROC package body implements the business logic behind the Create Consumption Advice concurrent program in Oracle E-Business Suite. Consumption advice processing supports procurement arrangements such as supplier consignment inventory and pay-on-use (POO) models, where goods are held at a site but ownership and payment obligations transfer only at the point of consumption. The package identifies material consumption transactions and transforms them into the evidence required to relieve consigned stock and to create or update the corresponding purchasing documents.

The source file is INVRCADB.pls, with a header revision history extending from its creation in November 2002 through maintenance patches in 2013. The header identifies the package as Oracle copyrighted material and attributes the internal procedure list, indicating a design divided between a top-level driving routine and parallelisable worker routines. The ETRM repository classifies the package under owner APPS with an API classification of OTHER, meaning it is an internal, non-public interface rather than a formally supported open API. It is referenced by one other package within the EBS schema set.

Key Procedures and Functions

The ETRM metadata documents two procedures for this package, although the source header enumerates a broader private procedure list:

  • CONSUMPTION_TXN_MANAGER — the principal driver procedure. It manages the overall consumption advice run: selecting eligible consumption transactions, coordinating the creation of the advice records, and controlling the worker processes that carry out the detailed processing. Historical bug fixes recorded in the header address a performance issue (Bug 4863365) and, critically, the prevention of duplicate release transactions when the concurrent program is executed in parallel (Bug 4574159). This procedure is therefore the entry point invoked by the concurrent program.
  • CONSUMPTION_TXN_WORKER — the worker procedure that processes the transaction subset assigned to it by the manager. A 2006 modification (Bug 5006151) adjusted the exit condition for the worker, and separate fixes relate to profile option handling (Bug 4599072) and to the addition of the BLANKET_PRICE and PO_DISTRIBUTION_ID columns to the consumption transaction table (Bug 4969421).

The header additionally lists private supporting routines including Update_Consumption, Load_Consumption, Load_Summarized_Quantity, Delete_Record, Batch_Allocation, Submit_Worker, Wait_For_All_Workers, Wait_For_Worker, Has_Worker_Completed, Generate_Batch_Id, and the logging routines Generate_Log, Log, and Log_Initialize. These provide batch partitioning, worker synchronisation, and error reporting; error messages are stored in the MCT table per the September 2003 change note.

Tables Accessed

The documented table references indicate both inventory and purchasing integration:

Usage Notes

This package is invoked through the Create Consumption Advice concurrent program, generally scheduled to run periodically so that accumulated consumption is converted into purchasing documentation. Direct calls from forms are not the intended pattern. Because the package is classified as OTHER rather than as a public API, customisations should not call its procedures directly; supported extension points should be used instead. Implementations running the concurrent program in parallel must rely on the duplicate-release protections added by the documented bug fixes, and any diagnostic output is available through the built-in logging routines and the consumption transaction table's error columns.