Search Results gmi_move_order_global




Overview
Explore in AI Chat

Overview

GMI_PICK_RELEASE_UTIL is a utility package in the APPS schema that supports pick release and pickslip generation within the Oracle Process Manufacturing (OPM) and Oracle Shipping Execution integration, commonly encountered in EBS 12.1.1 and 12.2.2 environments. The package is classified as a UTIL API, meaning it is not a public, transaction-oriented API in the traditional sense but rather an internal helper library invoked by other PL/SQL units to perform allocation, pickslip creation, delivery detail retrieval, and transaction update operations. Its principal internal dependency is GMI_MOVE_ORDER_GLOBAL, which links the utility to OPM move order processing. In the dependency graph, GMI_PICK_RELEASE_UTIL references FND_API for the standard EBS API framework and WSH_INV_DELIVERY_DETAILS_V for shipping delivery detail information, while it is referenced by GMI_PICK_RELEASE_PVT, GMI_PICK_WAVE_CONFIRM_PVT, and GMI_RESERVATION_UTIL.

The package's role is to bridge OPM inventory transactions with Oracle Shipping Execution objects, enabling pick release and pickslip processing for process manufacturing organizations.

Key Procedures and Functions

Documented procedures and functions total four, as identified in the ETRM metadata:

  • GET_DELIVERY_DETAILS — Retrieves delivery detail records, typically used to identify the shipping delivery lines associated with a pick release or move order. This function supports downstream allocation and pickslip logic by returning the relevant delivery detail information.
  • CREATE_MANUAL_ALLOC_PICKSLIP — Creates a pickslip based on manual allocation, allowing users to allocate inventory to a delivery detail and generate the corresponding pickslip outside the standard automatic pick release flow.
  • CREATE_PICK_SLIP_AND_PRINT — Creates a pickslip and triggers its printing, combining pickslip generation with the document output step required for warehouse operations.
  • UPDATE_TXN_WITH_PICK_SLIP — Updates the associated inventory transaction records to reflect the pickslip number or pickslip-related transaction data, maintaining linkage between OPM transactions and shipping execution pickslips.

Parameter lists are not documented in the excerpt and are deliberately not reproduced here; callers should inspect the package specification in the EBS instance for exact signatures.

Tables Accessed

The package accesses several tables through APPS synonyms:

  • IC_ITEM_MST — OPM item master, used for item-level validation and attributes during allocation and pickslip creation.
  • IC_TRAN_PND — OPM pending inventory transactions, used to record or update transaction records associated with pickslip activity.
  • IC_TXN_REQUEST_HEADERS — OPM move order (transaction request) headers, linking pick release operations to move orders.
  • IC_WHSE_MST — OPM warehouse master, used for warehouse validation and defaulting.
  • WSH_PICKING_BATCHES — Oracle Shipping picking batches, supporting pickslip batch assignment.
  • WSH_SHIPPING_PARAMETERS — Shipping Execution parameters, used to honor configuration such as pickslip numbering and printing behavior.

Additionally, the package references WSH_INV_DELIVERY_DETAILS_V and GMI_MOVE_ORDER_GLOBAL.

Usage Notes

This utility package is typically invoked indirectly rather than called directly from forms or concurrent programs. It is referenced by GMI_PICK_RELEASE_PVT, GMI_PICK_WAVE_CONFIRM_PVT, and GMI_RESERVATION_UTIL, indicating it services pick release, wave confirmation, and reservation workflows in process manufacturing. Custom code should generally call the public PVT layer rather than this utility. Direct invocation should be limited to extension development, and signatures must be verified against the specific EBS release, as OPM internal APIs can vary between 12.1.1 and 12.2.2.