Search Results gmi_reservation_util




Overview
Explore in AI Chat

Overview

APPS.GMI_AUTO_ALLOCATE_PUB is a public PL/SQL package belonging to the Process Manufacturing (GMI) family of applications in Oracle E-Business Suite. Its principal business function is to automate the allocation and reservation of on-hand inventory to demand sources — typically sales orders, transfer orders, and internal requisitions — within a process manufacturing environment. In the 12.1.1 and 12.2.2 releases, the package operates as the public API entry point for auto-allocation logic, encapsulating the rules that select available lots, warehouses, and inventory locations and record the resulting reservations. Its "PUB" classification indicates it is a documented, supported interface intended for callers external to the package itself, distinct from private ("PVT") implementation packages that carry the underlying validation and reservation mechanics.

Key Procedures and Functions

The ETRM metadata documents a single public procedure for this package:

  • ALLOCATE_INVENTORY — This is the sole documented entry point. It performs the auto-allocation routine: given incoming demand, it determines eligible inventory and creates the corresponding allocation or reservation records. The procedure is expected to accept the demand and organizational context as its calling parameters and to return a status along with the standard FND_API message list for error reporting, consistent with Oracle's public API conventions. Parameter lists are not enumerated in the documented metadata and are not reproduced here; callers should consult the package specification for exact signatures.

Tables Accessed

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

  • IC_ITEM_MST — Process manufacturing item master; supplies item attributes such as lot control and allocation-relevant flags.
  • IC_WHSE_MST — Warehouse master; defines the physical warehouse records considered during allocation.
  • IC_TRAN_PND — The pending inventory transaction table; allocation results are staged here before posting to the inventory ledger.
  • IC_ITEM_CPG — Item copy group attributes, used to qualify items eligible for allocation.
  • OE_ORDER_LINES_ALL — Order Management order lines; the primary demand source for sales-order allocation.
  • OP_ORDR_DTL — Process order detail; supplies process manufacturing demand records.
  • OP_CUST_MST — Customer master; provides customer context for the demand being fulfilled.
  • OP_ALOT_PRM — Lot parameters, governing lot selection and lot-level allocation behavior.
  • SY_ORGN_MST — Organization master; identifies the inventory organization in which allocation occurs.
  • FND_USER — Standard application user table, used to attribute the allocation to the invoking user.

Usage Notes

GMI_AUTO_ALLOCATE_PUB is not typically invoked directly by end users. It is called programmatically by other EBS components — notably GMI_AUTO_ALLOC_BATCH_PKG for batch auto-allocation, GMI_RESERVATION_PVT and GMI_RESERVATION_UTIL for reservation handling, and GMI_ALLOCATE_INVENTORY_PVT and GMI_VALIDATE_ALLOCATION_PVT for allocation and validation logic. This explains why the user search term "gmi_reservation_util" resolves to this object: GMI_RESERVATION_UTIL is a downstream consumer of this package. In practice, auto-allocation is triggered from Process Manufacturing order entry forms, from concurrent programs that process allocation in batch, and from custom extensions that require API-driven allocation rather than the standard UI. Custom callers should invoke ALLOCATE_INVENTORY within the standard FND_API error-handling framework and validate the returned status before committing.