Search Results gmi_pick_wave_confirm_pub




Overview
Explore in AI Chat

Overview

The APPS.GMI_PICK_WAVE_CONFIRM_PUB package is a public PL/SQL API belonging to the Oracle Process Manufacturing (OPM/GMI) inventory application within Oracle E-Business Suite 12.1.1 and 12.2.2. Its principal business function is to confirm the picking activity associated with a pick wave in the warehouse. A pick wave is a grouping of move order lines released together so that warehouse personnel can retrieve material from inventory locations and stage it for downstream consumption, shipping, or production. Once the physical picking is complete, the confirmation step updates the system so that the reserved or allocated quantities are formally recognized as picked, and subsequent transactional processes (such as staging, shipping, or transfer to manufacturing) can proceed. By exposing this logic through a documented public API, the package allows the confirmation operation to be invoked programmatically rather than exclusively through the standard OPM inventory forms, thereby supporting integration with custom extensions, third-party warehouse management systems, and automated material-handling environments.

Key Procedures and Functions

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

  • PICK_CONFIRM — The core entry point used to confirm pick activity for move order lines grouped within a pick wave. It encapsulates the business validations and transactional updates required to move a pick wave from a released/allocated state to a confirmed state. Because the parameter interface is not exposed in the documented metadata, integrators should obtain the exact signature from the package specification source or the appropriate OPM API documentation before calling it.

Tables Accessed

The documented metadata identifies a reference to the table access via the APPS synonym PLITBLM. In the OPM data model, this object is associated with pick list and move order line processing, and it underpins the storage of pick-related line information that PICK_CONFIRM must read and update to record confirmation against the wave. The package’s dependency list also records a reference to the internal object GMI_MOVE_ORDER_GLOBAL, which provides the underlying move order processing functionality that the public confirm API leverages. Through that dependency, the confirmation logic interacts with the move order header and line structures that define the pick wave and the material to be confirmed.

Usage Notes

This package is classified as a PUB (public) API, indicating that it is intended for supported external invocation rather than internal-only use. It is typically called from the OPM inventory pick confirmation form, from custom PL/SQL routines that automate wave confirmation, or from external WMS applications that need to push confirmation results into EBS. Because the package depends on FND_API, the standard Oracle Applications error-handling framework, callers should expect a standard API return status and message structure and should check the return status after each invocation rather than relying on exceptions alone. The package is referenced by zero other packages according to the metadata, confirming that it functions as an entry point rather than a shared utility. In Oracle EBS 12.1.1 and 12.2.2 the object resides in the APPS schema and retains a VALID status. Before implementing custom calls, developers should verify the exact parameter list from the source specification, wrap calls in appropriate transaction control, and test thoroughly, as confirmation affects inventory quantities, move order status, and downstream reservations.