Search Results pick_confirm

Overview

The APPS.INV_PICK_WAVE_PICK_CONFIRM_PUB package body is the public API layer within Oracle EBS Inventory that supports pick confirmation processing for move orders and pick waves. Its principal purpose is to confirm that material has been physically picked from inventory, which triggers the creation of the corresponding material transactions. This package is the public entry point used by the sales order picking, shipping, and warehouse execution flows, as well as by Oracle Warehouse Management (WMS) driven pick tasks. In the 12.1.1 and 12.2.2 release families, this object underpins the transaction integration between move order lines, picking, and the material transaction interface, allowing the user to confirm picks in a single atomic API call. ETRM classifies it as a PUBLIC API, meaning it forms a supported, callable interface intended for consumption by other Oracle EBS modules and approved customizations.

Key Procedures and Functions

The package exposes three documented procedures: PICK_CONFIRM, INV_TM_LAUNCH, and TRACELOG. PICK_CONFIRM is the core routine—it accepts move order line detail and transaction mode parameters, performs the validation of pick quantities and lot/serial information, and drives the material transaction confirmable to the inventory transaction interface. INV_TM_LAUNCH is the internal transaction manager launcher that submits or processes the material transaction work, coordinating the transaction header creation that results from the pick confirmation. TRACELOG is a diagnostic helper that writes trace messages to the debug log when the INV_DEBUG_TRACE profile option is enabled; it is used for troubleshooting during implementation and support. The metadata does not enumerate per-parameter behavior for these routines, so parameter lists are intentionally omitted; callers should reference the published API documentation for the specific argument structures.

Tables Accessed

The package reads and writes through APPS synonyms for several key inventory tables. MTL_MATERIAL_TRANSACTIONS_S and MTL_MATERIAL_TRANSACTIONS_TEMP are used to record and stage the transaction header and detail information generated when a pick is confirmed. MTL_SERIAL_NUMBERS and MTL_SERIAL_NUMBERS_TEMP support serial-controlled items, validating and recording the serial numbers assigned to the confirmed picks. MTL_TRANSACTION_LOTS_TEMP holds lot-controlled transaction lines, while DUAL is used for single-row sourcing and PLITBLM is referenced for the PL/SQL integer/table-style array operations used in transaction processing. Together these tables represent the standard Inventory material transaction and serial/lot control database structures required to post pick confirmations.

Usage Notes

This API is typically invoked from Oracle Shipping, Oracle WMS, or custom pick confirmation forms and concurrent programs, and it is referenced by thirteen other packages according to ETRM metadata. Because it is classified as a PUBLIC API, it is the supported interface for custom integrations that need to confirm picks on move orders without directly manipulating the base transaction tables. Callers should invoke it within a consistent transaction context and honor the p_api_version_number, p_init_msg_list, and p_commit conventions common to Oracle EBS PL/SQL APIs, checking x_return_status and the associated message stack before committing. Debug tracing is controlled through the INV_DEBUG_TRACE profile option, which is valuable when diagnosing pick confirmation failures during implementation and production support.