Search Results get_available_supply_demand

Overview

INV_RCV_AVAILABILITY is an Oracle E-Business Suite PL/SQL package owned by APPS that provides availability computation services for the Oracle Inventory and Receiving product family. Its principal business purpose is to calculate the quantity of an item that is available to satisfy a given supply or demand reference, taking into account organization, item, revision, lot, subinventory, locator, LPN, project, and task context. The package is classified under the API classification OTHER in ETRM for release 12.2.2, indicating that it is an internal technical utility rather than a formally published public API. The header comment (INVRCVAB.pls 120.4) shows the package was maintained through the 12.x code line and carries no ship flag ("noship"), which is characteristic of internal runtime support code bundled with the Inventory/Receiving modules.

The package includes a private debugging utility, PRINT_DEBUG, which reads the INV_DEBUG_TRACE profile option through FND_PROFILE.VALUE and routes trace output through INV_MOBILE_HELPER_FUNCTIONS.TRACELOG. This confirms the package is designed for diagnosable, profile-controlled execution—typical of high-volume transactional logic where tracing must be activated selectively by a system administrator.

Key Procedures and Functions

ETRM documents a single procedure, GET_AVAILABLE_SUPPLY_DEMAND. Although the full parameter signatures are not enumerated in the metadata, the source excerpt indicates the procedure returns an available quantity and the associated unit-of-measure codes, accepts a supply/demand code and type identifier, and resolves availability against a full item/subinventory/locator/LPN context plus project and task attributes. It also follows the standard EBS API conventions for a return status, message count, and message data, and supports an initialization flag for the message list. The procedure is therefore the core availability engine of the package: given a supply/demand reference, it resolves the eligible on-hand and inbound supply and returns the net quantity available. No other documented procedures or functions exist in the package per the ETRM record.

Tables Accessed

The package reads and writes through APPS synonyms for the following base tables:

• MTL_SYSTEM_ITEMS — item definition master, used to validate item context and derive primary UOM and related item attributes.
• MTL_TXN_REQUEST_HEADERS / MTL_TXN_REQUEST_LINES — move-order headers and lines, used to resolve supply/demand references originating from inventory move orders.
• RCV_SUPPLY — receiving supply records, representing expected inbound receipts that contribute to available supply.
• RCV_TRANSACTIONS — historical receiving transactions used to reconcile completed receipts against supply.
• RCV_TRANSACTIONS_INTERFACE — the open receiving interface, used when pending interface records must be considered in availability.

Usage Notes

Because the package is classified as OTHER, it is intended for internal consumption by Oracle Inventory and Receiving flows rather than for direct customer or partner calls. It is referenced by one other package in ETRM; that dependent object is the primary expected caller. In practice, the procedure is invoked from Inventory and Receiving runtime logic—move-order processing, receiving supply/demand resolution, and mobile receiving flows (evidenced by the INV_MOBILE_HELPER_FUNCTIONS trace dependency). Customers should not call GET_AVAILABLE_SUPPLY_DEMAND directly from custom code, since its signature and semantics are not governed by Oracle's public API commitment and may change between releases. When diagnosing unexpected available-quantity results, administrators should set the INV_DEBUG_TRACE profile to 1 and inspect the trace log produced by PRINT_DEBUG to capture the input parameters and processing stages.