Search Results gmi_reservation_pvt




Overview
Explore in AI Chat

Overview

GMI_RESERVATION_PVT is an Oracle Application Object Library private (PVT) PL/SQL package owned by the APPS schema in Oracle E-Business Suite, with validated status across both 12.1.1 and 12.2.2 releases. It forms the internal implementation layer of the Process Manufacturing (OPM) reservation framework and is responsible for creating, maintaining, and discharging inventory reservations against discrete and process manufacturing items. The package bridges the Oracle Inventory reservation engine, the Order Management order line structure, and the Warehouse Management shipping modules, allowing OPM supply chain transactions to hard-allocate stock to specific demand documents.

The PVT suffix indicates this is a private, non-public API. It is not intended for direct invocation by third-party code; instead, it is consumed by the companion public package GMI_RESERVATION_PUB and by GMI_RESERVATION_UTIL, which expose controlled entry points to forms, concurrent programs, and integration routines.

Key Procedures and Functions

The documented API surface includes nine procedures and functions that cover the full reservation lifecycle:

  • CREATE_RESERVATION — establishes a new reservation record tying demand to on-hand stock.
  • UPDATE_RESERVATION — modifies quantity or attribute values on an existing reservation.
  • DELETE_RESERVATION — removes a reservation, releasing the allocated quantity.
  • TRANSFER_RESERVATION — moves reservation quantities between warehouses, lots, or demand references.
  • QUERY_RESERVATION — retrieves reservation detail for validation and display purposes.
  • CALCULATE_RESERVATION — derives the reservation quantity required based on item and demand attributes.
  • CALCULATE_PRIOR_RESERVATIONS — evaluates existing reservations ahead of the current request, supporting allocation sequencing rules.
  • CHECK_SHIPPING_DETAILS — validates shipment and delivery attributes before reservation or transfer is permitted.
  • QUERY_QTY_FOR_ATP — returns available-to-promise quantities used to determine reservable stock.

Tables Accessed

The package operates across OPM and discrete manufacturing data through APPS synonyms:

Usage Notes

GMI_RESERVATION_PVT should never be called directly from custom code. The supported integration path is through GMI_RESERVATION_PUB, which validates inputs and delegates to this private package. Internal dependencies on FND_API and INV_RESERVATION_GLOBAL confirm the package participates in the standard EBS API error-handling and Inventory reservation frameworks. Typical invocation occurs from OPM reservation forms, order management reservation workflows, warehouse shipping confirmation, and concurrent reservation programs. Customizations requiring reservation logic in a 12.1.1 or 12.2.2 environment should reference the public wrapper, preserving upgrade safety and consistent error handling.