Search Results inv_supplier_consigned_enabled




Overview
Explore in AI Chat

Overview

APPS.MRP_GET_ONHAND is a supply chain planning utility package in Oracle E-Business Suite (12.1.1 / 12.2.2) that retrieves on-hand quantity information for a given item and inventory organization. It is classified as OTHER in the ETRM metadata, indicating it is not a formal public API but rather an internal helper used by Oracle's planning and inventory applications. The package exposes a small set of documented entry points—GET_OH_QTY and DO_RESTOCK—while internally relying on private logging helpers and dynamic SQL to resolve on-hand balances, including consigned and VMI inventory scenarios. The header comment ($Header: MRPGEOHB.pls 120.0) confirms it belongs to the MRP (Material Requirements Planning) product family and has been stable since the 2005 code line, which aligns with its continued presence in the 12.x release streams.

Key Procedures and Functions

  • GET_OH_QTY — The primary routine. It returns the on-hand quantity for a specified item and organization, with a flag to control whether non-nettable (non-net) subinventory stock is included. The implementation selects the on-hand source dynamically: when include_nonnet equals 1, the source is set to NULL; otherwise it defaults to 2. It also inspects the INV_SUPPLIER_CONSIGNED_ENABLED and INV_VMI_ENABLED profile options and, when supplier consignment is enabled, builds and executes a dynamic PL/SQL block that delegates to INV_CONSIGNED_VALIDATIONS_GRP.GET_PLANNING_QUANTITY to obtain the planning quantity. The procedure returns both the quantity and standard return status / message data out parameters.
  • DO_RESTOCK — The second documented routine. As the name implies, it supports restocking logic associated with the on-hand retrieval, providing the package's supporting behavior for replenishment-oriented callers. The ETRM metadata documents its existence but not its parameter list.
  • LOG_DEBUG (private) — This is the routine most relevant to the user's search for "log_debug". It writes a debug buffer to the concurrent manager log via FND_FILE.PUT_LINE, but only when the module-level flag G_MRP_DEBUG equals 'Y'. Otherwise it silently returns, so no debug output is produced in normal execution. Exceptions are swallowed with a RETURN to guarantee that diagnostic logging never interrupts planning logic.
  • LOG_ERROR (private) — A companion logger that writes to the log only when fnd_global.conc_request_id is greater than zero, ensuring error messages appear exclusively in a concurrent program context.

Tables Accessed

The ETRM metadata does not enumerate specific base tables or APPS synonyms referenced by this package. This is consistent with the source excerpt, which relies on sys.dual for the system date and delegates the substantive on-hand lookup to INV_CONSIGNED_VALIDATIONS_GRP.GET_PLANNING_QUANTITY and the underlying on-hand source selection rather than issuing direct SQL against MTL_ONHAND_QUANTITIES or MTL_SUPPLY. Documented behavior therefore centers on profile option values and the consigned validations group, and any table access occurs indirectly through those calls.

Usage Notes

MRP_GET_ONHAND is typically invoked from within Oracle planning and inventory flows where a current on-hand or planning quantity must be resolved for an item-organization pair, including scenarios involving supplier-consigned or VMI inventory. It is referenced by one other package per the ETRM metadata, so it functions as a dependency rather than a top-level entry point. The "log_debug" search term maps directly to the private LOG_DEBUG procedure: to capture debug output, G_MRP_DEBUG must be set to 'Y' and the session must be running under the concurrent manager so that FND_FILE.PUT_LINE routes messages to the request log. Because the package is classified as OTHER and not a published API, custom code should use it cautiously and prefer supported public APIs where available.