Search Results gme_reserve_conc




Overview
Explore in AI Chat

Overview

GME_RESERVE_CONC is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports reservation processing within the Process Manufacturing (OPM) and Order Management integration flow. Its name and documented dependencies indicate that it serves as a concurrent-oriented utility for driving reservation logic against sales order and delivery inventory. In Oracle EBS 12.1.1 and 12.2.2, the package is registered as a VALID database object and is classified under the ETRM API taxonomy as OTHER, meaning it is not a published open interface or public API but an internal supporting package invoked by other application components.

The documented dependency on APPS.OE_ORDER_PUB establishes the package's role in the order management domain. The presence of a documented procedure named MAKE_TO_ORDER further indicates its involvement in make-to-order supply scenarios, where reservations are applied against specific demand rather than generic stock. The package is self-referencing in the dependency report, which is consistent with internal calls between its own procedures and a concurrent-program entry point.

Key Procedures and Functions

The ETRM metadata documents three procedures and functions within this package:

  • MAKE_TO_ORDER — Handles reservation activity associated with make-to-order demand. Based on the package's dependency on OE_ORDER_PUB, this procedure is understood to process order lines flagged for make-to-order supply so that the corresponding inventory is reserved or linked to the originating sales order.
  • RESERVE_ELIGIBLE — Determines and processes reservation-eligible records. This procedure is the core filtering routine that identifies which demand or delivery records qualify for reservation before reservation records are written to the inventory tables.
  • SET_PARAMETER_FOR_WF — Configures parameters for workflow processing. This procedure supports the Oracle Workflow integration associated with the reservation concurrent flow, allowing runtime parameters to be passed into the workflow-driven reservation logic.

Parameter lists for these routines are not published in the supplied metadata and should not be assumed. Consumers should interrogate the package specification in the target instance before calling any routine directly.

Tables Accessed

The documented table references, resolved through APPS synonyms, are:

  • MTL_RESERVATIONS — The core inventory reservation table. GME_RESERVE_CONC reads and writes reservation records here to create, update, or release reservations against eligible demand.
  • WSH_DELIVERY_DETAILS — Shipping execution delivery detail records. The package references this table to associate reservations with specific delivery lines, linking order demand to outbound shipment activity.
  • DBMS_SQL — The Oracle-supplied dynamic SQL built-in, indicating that portions of the package construct and execute SQL statements dynamically at runtime.
  • DUAL — The standard single-row utility table, typically used for parameter validation or single-value lookups.

Usage Notes

GME_RESERVE_CONC is an internal APPS-level package rather than a public API. It is most commonly invoked through a concurrent program that drives the reservation batch, and its SET_PARAMETER_FOR_WF routine confirms a Workflow-backed execution path. Because the package depends on OE_ORDER_PUB, it is expected to operate within order management and process manufacturing flows where reservations must be synchronized with sales order and delivery data.

Custom code should avoid direct invocation unless the target procedure signature has been validated in the specific instance. In 12.1.1 and 12.2.2, no other packages are documented as referencing GME_RESERVE_CONC, indicating a narrow consumption footprint. Any modification or extension should be performed on a copy, and the package should be recompiled after dependency changes to MTL_RESERVATIONS or WSH_DELIVERY_DETAILS structures.