Search Results release_wms_wave

Overview

WSH_PICKING_BATCHES_GRP is a Group (GRP) type PL/SQL package in the APPS schema of Oracle E-Business Suite. It serves as the grouping and orchestration layer for picking batch operations within the Oracle Warehouse Management and Shipping Execution modules. The package itself is not the primary public API — that role belongs to WSH_PICKING_BATCHES_PUB — but rather a wrapper that aggregates and coordinates the underlying business logic for creating and releasing picking batches and WMS waves. It abstracts the complexity of invoking the base WSH_PICKING_BATCHES processing logic, providing a single entry point that downstream packages can call without directly interacting with the underlying batch engine. This grouping package is tightly coupled with the Picking Batches subsystem and is a foundational component for wave planning, pick release, and internal order processing flows in Oracle EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

ETRM documents three procedures/functions in this package, each serving a distinct phase of picking batch lifecycle management:

• CREATE_BATCH — Creates a picking batch from eligible delivery details based on picking rules. The procedure identifies candidates for picking, applies picking rules, and commits the resulting batch to the WSH_PICKING_BATCHES table. It is normally invoked before release to organize picking work into manageable groups.
• RELEASE_BATCH — Releases one or more picking batches for picking execution. Once a batch is released, the associated delivery details and pick slips become actionable in the warehouse. This procedure ties into delivery detail and new delivery records to make the batch visible to the picking process.
• RELEASE_WMS_WAVE — Releases a WMS (Warehouse Management System) wave associated with a picking batch. This bridges the shipping picking batch construct with the WMS wave execution engine, allowing wave lines to be processed by the warehouse management subsystem.

The public counterpart WSH_PICKING_BATCHES_PUB provides the externally exposed interface and invokes these grouping procedures internally.

Tables Accessed

The package reads and writes to core Shipping Execution, Order Management, and Inventory tables via APPS synonyms. Key tables include:

• WSH_PICKING_BATCHES — the primary batch record store, holding batch header and status information.
• WSH_DELIVERY_DETAILS and WSH_NEW_DELIVERIES — delivery-level data that determines which lines are included in a batch.
• WSH_PICKING_RULES — rules used to determine picking eligibility and sequencing during CREATE_BATCH.
• MTL_ITEM_CATEGORIES, MTL_CATEGORY_SETS, and MTL_SYSTEM_ITEMS — item and category data used to apply picking rules and validate items.
• MTL_ITEM_LOCATIONS — subinventory and locator information for picking.
• OE_ORDER_HEADERS_ALL, OE_SETS, and OE_TRANSACTION_TYPES_TL — sales order context for the deliveries being picked.
• WMS_WP_WAVE_LINES — WMS wave line records operated upon by RELEASE_WMS_WAVE.
• PLITBLM — a PL/SQL index-by table used internally for list processing.

Usage Notes

The package is typically invoked indirectly. Standard entry points include the Shipping Transactions and Picking Batch forms (Pick Release), the Pick Release concurrent program, and the Warehouse Management wave planning engine (WMS_WAVE_PLANNING_PVT). Custom code should prefer WSH_PICKING_BATCHES_PUB for forward compatibility, as it delegates to this grouping package. ETRM lists five packages as referencing WSH_PICKING_BATCHES_GRP, including AHL_MM_MTL_MGT_PVT, CSD_INTERNAL_ORDERS_PVT, CSD_PROCESS_PVT, WMS_WAVE_PLANNING_PVT, and WSH_PICKING_BATCHES_PUB, which confirms its role as a shared internal service layer. Because it is a GRP-class package, it is not intended as a supported public interface; modifications or direct calls should be limited to extensions that understand the shipping and wave data model.