Search Results validate_pick

Overview

WMS_OVERPICK is an Oracle Warehouse Management (WMS) PL/SQL package body owned by the APPS schema. Its business purpose is to determine whether a locator contains sufficient on-hand quantity to satisfy an outbound picking request, and to return the quantity that is available to transact. The package operates against Oracle's quantity tree structures, which aggregate on-hand balances by organization, locator, item, revision, lot, and status. Rather than reading individual on-hand rows directly, WMS_OVERPICK queries this pre-aggregated tree to arrive at a fast, consistent answer regarding pick feasibility.

The package is classified as OTHER in the Oracle E-Business Suite Technical Reference Manual for Release 12.2.2, indicating it is a supporting utility rather than a public, frozen API. It is part of the warehouse execution and transaction validation layer that governs material movement within WMS-enabled organizations. The header comment identifies a single functional entry point, VALIDATE_OVERPICK, whose contract is described below.

Key Procedures and Functions

The 12.2.2 metadata documents exactly one procedure: VALIDATE_OVERPICK. Its stated purpose, drawn from the package source comments, is twofold:

• Query the quantity tree to establish whether there is sufficient quantity to be picked in a given locator.
• Return an indicator result—1 when the requested quantity is available to pick within the locator, and 0 otherwise.
• Return the available-to-transact quantity expressed in the same unit of measure in which the procedure was invoked.

The procedure declares a standard EBS API signature shape, including a return status, message count, and message data for error communication, together with parameters carrying the transaction temporary identifier, the requested quantity, and the unit of measure. The source also references several local variables populated from material transaction temporary records and item master attributes, including lot control, revision control, and serial number control codes. A private debug helper procedure, MDEBUG, is present in the body but is disabled by a nulled body; it reads the INV_DEBUG_TRACE profile option when active. No other procedures or functions are documented for this package.

Tables Accessed

Two tables are documented as referenced through APPS synonyms:

• MTL_MATERIAL_TRANSACTIONS_TEMP — the transaction temporary table, keyed by transaction_temp_id. WMS_OVERPICK reads this table to resolve the organization, locator, item, revision, lot, and primary unit of measure associated with the pending pick transaction before validating quantity availability.
• MTL_SYSTEM_ITEMS — the item master. It is read to obtain item control attributes such as lot control code, revision quantity control code, and serial number control code, which determine how the quantity tree must be interrogated.

The package additionally relies on the quantity tree structures referenced in its source comments; these are internal WMS aggregation objects rather than base transaction tables.

Usage Notes

WMS_OVERPICK is an internal validation utility rather than a user-facing feature. It is normally invoked from WMS picking and overpick processing flows, where the system must confirm that a selected locator can supply the required quantity before the pick is confirmed. The 12.2.2 metadata records no dependent packages referencing it, which indicates it is called directly from warehouse execution code paths rather than being wrapped by other documented APIs.

Because the signature uses NOCOPY OUT parameters and the message stack conventions typical of EBS PL/SQL APIs, callers must inspect the return status and message count rather than relying on exceptions alone. Customizations that call this package should treat it as an unsupported internal interface, since it is not published as a public API and its behavior is tied to the internal structure of the quantity tree.