Search Results get_planning_quantity




Overview
Explore in AI Chat

Overview

INV_CONSIGNED_VALIDATIONS_GRP is a validation and query group package in the Oracle E-Business Suite Inventory (INV) module. It provides the application programming interface layer used to determine consigned (Vendor Managed Inventory, or VMI) and planning quantities for inventory items when the owning organization differs from the organization that physically holds the material. In a consigned inventory model, the supplier retains ownership of goods held at the buyer's site until they are consumed, so the standard on-hand quantities maintained by Inventory are insufficient for return, receipt, or planning validations. This package resolves those gaps by returning consigned on-hand and available-to-transact quantities scoped by organization, item, revision, lot, subinventory, locator, sourcing, and demand reference.

The header comment identifies the package as INVVMIGB.pls, version 120.1, dated 2005/06/16, confirming its lineage as an early VMI enablement component that remains in the 12.1.1 and 12.2.2 code lines. The API classification is GRP, indicating it is a group-type package primarily consumed by other EBS programs rather than being a standalone user-facing interface.

Key Procedures and Functions

  • GET_CONSIGNED_QUANTITY — Returns the consigned (VMI) quantity for a given combination of organization, owning organization, planning organization, item, and control attributes. It exposes two overloads: the documented public form accepts the full validation context and returns consigned on-hand (x_qoh) and available-to-transact (x_att) quantities, while an overloaded internal call propagates the same parameters and captures intermediate results before returning them to the caller.
  • GET_PLANNING_QUANTITY — Returns the planning quantity applicable to the consigned inventory context. This is the procedure most frequently targeted by searches for consigned planning balances, and it supports planning and supply/demand validation logic where consigned stock must be evaluated alongside owned inventory.
  • GET_PLANNING_SD_QUANTITY — Returns the planning quantity for a supply/demand (S/D) scenario. It extends planning quantity resolution to a specific demand source context, allowing callers to evaluate consigned planning availability against a named demand reference.

Tables Accessed

The ETRM metadata for this package does not enumerate the base tables it reads. Access is performed through APPS synonyms in the standard EBS manner. In practice, consigned and planning quantity validation draws on inventory on-hand and consigned-inventory query views, item and revision/lot/serial control attributes, subinventory and locator definitions, and the owning-organization relationships that distinguish the operator organization from the planning organization. The package performs read-oriented validation and does not maintain transactional balances itself.

Usage Notes

INV_CONSIGNED_VALIDATIONS_GRP is invoked programmatically rather than from a dedicated concurrent program. The ETRM metadata records that it is referenced by one other package, consistent with its role as a shared helper for higher-level VMI processing. Typical callers include consigned inventory transaction validation routines, return-to-vendor and receipt flows, and planning or sourcing programs that must confirm consigned availability before committing material movements. Custom extensions integrating with consigned inventory should call this group through its documented procedure interfaces, supplying the required organization, item, control, and demand-source parameters, and should interpret x_return_status, x_msg_count, and x_msg_data to surface validation errors. Because the wrapper overload delegates to an internal overload, callers should use the top-level signature and avoid dependence on internal implementation details, which are subject to change in future patches.