Search Results gmi_pick_confirm_pub




Overview
Explore in AI Chat

Overview

APPS.GMI_PICK_CONFIRM_PUB is a public PL/SQL API package within the Oracle E-Business Suite Process Manufacturing (OPM) module, specifically serving the warehouse management and material picking functions of Oracle Process Manufacturing. The package provides the programmatic interface for confirming pick transactions against material requests and delivery details in an OPM-enabled warehouse environment. In Oracle EBS 12.1.1 and 12.2.2, this API acts as the public entry point through which external callers, including Oracle Warehouse Management (WSH) integration points and internal OPM modules, validate and commit the removal of material from inventory in fulfillment of a pick instruction.

The package is documented as VALID in the APPS schema and is classified as a PUB (public) API, indicating it is intended to be called by other packages and modules rather than being reserved for internal private use. It follows the standard Oracle EBS API conventions, depending on FND_API for the common error handling, message stacking, and return status framework used across EBS public APIs.

Key Procedures and Functions

Two documented subprograms are exposed by GMI_PICK_CONFIRM_PUB:

  • PICK_CONFIRM — This is the principal business procedure of the package. It processes the confirmation of a pick transaction for OPM inventory. Its purpose is to validate the pick details, apply the inventory transaction against pending material, and record the confirmed quantity movement, propagating the relevant updates to warehouse and delivery records. As a public API, it is designed to be invoked in a controlled manner with standard EBS error handling.
  • PRINTMSG — A utility procedure responsible for message output and diagnostic reporting. It supports the logging or display of informational, warning, and error messages generated during pick confirmation processing, typically leveraging the standard message printing facilities available in EBS server-side PL/SQL.

The metadata does not expose parameter signatures. Parameter lists are therefore not reproduced here; callers should reference the package specification in the APPS schema for exact argument definitions.

Tables Accessed

The package operates against the following documented objects, referenced through APPS synonyms:

  • IC_ITEM_MST_B — The OPM item master base table, consulted to validate the item being picked.
  • IC_TRAN_PND — The pending inventory transaction table, which holds inventory movements awaiting validation and posting; pick confirmations are staged and processed here.
  • IC_TXN_REQUEST_LINES — The material transaction request lines that define the pick demand being confirmed.
  • IC_WHSE_MST — The OPM warehouse master, used to validate warehouse context for the pick.
  • WSH_DELIVERY_DETAILS — The Oracle Shipping delivery details table, linking the OPM pick to the outbound delivery line.

Additional referenced objects include PLITBLM (a standard EBS message/logging table), UTL_FILE (for file-based diagnostics), and V$PARAMETER (for database instance parameter inspection).

Usage Notes

GMI_PICK_CONFIRM_PUB is invoked indirectly rather than directly by end users. The ETRM dependency data shows it is referenced by the private package GMI_PICK_WAVE_CONFIRM_PVT, which handles wave-based pick confirmation logic, and by another instance of GMI_PICK_CONFIRM_PUB itself. This indicates that wave picking and related OPM warehouse workflows call the public API as part of their processing. Custom extensions and integrations that need to confirm OPM picks programmatically should call the public PICK_CONFIRM procedure, observing the standard EBS API pattern of checking the return status and inspecting the error message stack. Because the package relies on PLITBLM and UTL_FILE, administrators should ensure appropriate directory and logging configuration exists in the deployment environment.