Search Results is_serial_controlled

Overview

INV_EXPRESS_PICK_PUB is a public PL/SQL package in the Oracle E-Business Suite Inventory (INV) module that supports the Express Pick and Pick Confirmation workflow. Its primary role is to validate and process move order picking activity, including reservation detail checking, staging of reservations, release of picks, and capture of serial numbers for material movement. The package body carries the header signature INVEXPRB.pls 120.4, indicating it is a standard Oracle-shipped package rather than a custom extension. The "PUB" classification in the API naming convention confirms that its procedures are intended to be called by external programs, forms, and other APIs rather than being reserved for internal use only.

Because the package addresses picking and staging logic, it is particularly relevant to organizations that pick serial-controlled or lot-controlled inventories and need confirmation that the correct quantity, locator, revision, and serial information is reserved before a transaction is executed.

Key Procedures and Functions

• PICK_RELEASE — Releases a picking reservation so that the associated material movement can proceed. It is the primary entry point for moving a pick from an allocated state into the released/confirmed picking state.
• STAGE_DD_RSV — Stages a delivery detail reservation, moving reserved quantity into a staging status. This supports the staging step between picking and shipping in a WMS-enabled or non-WMS environment.
• PICK_SERIAL_NUMBERS — Captures and records the serial numbers associated with a pick. This is the procedure most relevant when a user searches on "is_serial_controlled," as it governs whether serial number capture is required for the item being picked.

In addition to the documented public procedures, the body contains internal routines such as check_detailed_rsv, which evaluates whether a reservation is detailed enough for picking. This function tests whether lot numbers, revisions, locators, and subinventory values are present, and it uses INV_CACHE.set_item_rec to read item control attributes. It returns FALSE when the item is not serial, lot, or revision controlled at the required level, which is directly tied to serial control evaluation at runtime. A print_debug helper delegates trace output to INV_PICK_WAVE_PICK_CONFIRM_PUB.tracelog.

Tables Accessed

• MTL_SERIAL_NUMBERS / MTL_SERIAL_NUMBERS_TEMP — Read and written to validate, temporarily hold, and commit serial numbers during picking.
• MTL_MATERIAL_TRANSACTIONS_S — Provides transaction sequence context for the resulting material movement.
• MTL_PARAMETERS — Supplies organization-level inventory defaults, including serial and locator control behavior.
• MTL_SECONDARY_INVENTORIES — Validates subinventory attributes and locator control settings.
• MTL_SYSTEM_ITEMS — Provides item-level control flags such as serial control and lot control.
• MTL_TRANSACTION_TYPES — Supplies transaction type definitions used by the pick movement.
• WSH_DELIVERY_DETAILS — Links the picking activity to the delivery detail being fulfilled.
• DUAL and PLITBLM — Used for PL/SQL utility and lookup purposes.

Usage Notes

INV_EXPRESS_PICK_PUB is typically invoked from Oracle Inventory forms related to move orders, pick release, and express picking, and from concurrent programs that confirm picks. It may also be called by other public APIs; the metadata indicates one other package references it. Custom code integrating with express picking should call the documented procedures rather than the internal functions. Because the package relies on INV_CACHE, callers should be aware that item control values are cached per session. Serial-controlled items require PICK_SERIAL_NUMBERS to be executed before confirmation, and the internal reservation check enforces that required lot, revision, and serial attributes are supplied before a pick is accepted.