Search Results pick_serial_numbers

Overview

APPS.INV_EXPRESS_PICK_PUB is a public PL/SQL API package in Oracle EBS Inventory (INV) that supports the Express Pick and Pick Release functionality used during outbound order fulfillment. The package encapsulates the business logic required to convert move order lines into released picks, to stage delivery detail reservations, and to allocate serial numbers against inventory on hand. It is declared with AUTHID CURRENT_USER, meaning that its SQL statements execute under the privileges of the calling schema rather than the definer, which is typical of the EBS public API layer.

The package header carries the version string $Header: INVEXPRS.pls 120.2 2006/09/14 10:12:09 bradha noship $, confirming that the interface has been stable across the 12.1.1 and 12.2.2 release lines. It is documented in ETRM as an API classification of PUB and exposes three documented entry points: PICK_RELEASE, STAGE_DD_RSV, and PICK_SERIAL_NUMBERS. The user search term "stage_dd_rsv" corresponds directly to the second of these procedures.

Key Procedures and Functions

• PICK_RELEASE — The primary entry point for releasing move order lines into the picking process. It accepts a move order line table based on INV_Move_Order_PUB.TROLIN_TBL_TYPE, a grouping rule identifier, a partial-pick flag, and a reservation table of type inv_reservation_global.mtl_reservation_tbl_type. It returns a status table of type p_pick_release_status_tbl alongside the standard API return status, message count, and message data parameters. This procedure drives staging, reservation consumption, and pick confirmation for the supplied lines.
• STAGE_DD_RSV — Stages delivery detail reservation data for a single move order line. It receives one move order line record (Trolin_Rec_Type) and a reservation table, and updates the pick release status table in an IN OUT capacity. It emits the standard return status, message count, and message data outputs. This procedure is the internal staging routine invoked per line during a pick release cycle, and it is the object most commonly associated with the stage_dd_rsv search term.
• PICK_SERIAL_NUMBERS — Allocates serial numbers for a required quantity of a serialized item. It takes item, organization, revision, lot, subinventory, locator, required quantity, unit number, and reservation identifier inputs, and returns the available serial quantity, a temporary transaction identifier, a serial index, the API status outputs, and a serial number. The reservation and serial number parameters were added under Bug 5517498.

Tables Accessed

The package reads and writes a focused set of INV and WSH tables through APPS synonyms. MTL_MATERIAL_TRANSACTIONS_S supplies the transaction identifiers used when creating pick and staging transactions. MTL_PARAMETERS and MTL_SECONDARY_INVENTORIES provide the organization-level defaults and subinventory validation needed to determine valid staging locations. MTL_SYSTEM_ITEMS is consulted for item attributes, including serial control flags. MTL_SERIAL_NUMBERS and MTL_SERIAL_NUMBERS_TEMP support the serial allocation performed by PICK_SERIAL_NUMBERS. MTL_TRANSACTION_TYPES supplies the transaction type identifiers used for the generated material transactions. WSH_DELIVERY_DETAILS is the delivery detail source whose reservation rows are staged and updated. DUAL is used for scalar evaluations, and PLITBLM is the standard EBS message/error stack table used to accumulate API messages.

Usage Notes

INV_EXPRESS_PICK_PUB is normally invoked indirectly. The Oracle Shipping and Inventory pick release forms and concurrent programs call through the pick release workflow, which in turn calls this package to stage reservations and confirm picks. Custom extensions and bolt-on fulfillment code may call PICK_RELEASE directly when implementing bulk pick release outside the standard UI, provided the caller first constructs a valid move order line table and reservation table.

STAGE_DD_RSV is generally treated as a supporting routine called within a PICK_RELEASE loop rather than as a standalone integration point, though it is callable on its own for targeted reservation staging. PICK_SERIAL_NUMBERS may be called independently when serial allocation must be performed ahead of or separately from the main pick release. Callers should always initialize the message list, check x_return_status against FND_API.G_RET_STS_SUCCESS, and drain the message stack via the standard error-handling utilities. The package is referenced by one other package in the EBS code base, indicating a narrowly scoped dependency chain within the pick release subsystem.