Search Results wsh_picking_batches

Overview

The WSH_PICKING_BATCHES table is a core data object within the Shipping Execution (WSH) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the primary repository for information related to picking batches, which are logical groupings of delivery lines created to optimize the warehouse picking process. The table functions as a central hub, linking the picking operation to key shipping entities such as deliveries, trips, and trip stops, thereby enabling coordinated material movement from the warehouse to outbound shipping.

Key Information Stored

The table's primary key is the BATCH_ID, which uniquely identifies each picking batch. As indicated by its foreign key relationships, the table stores critical identifiers that define the batch's context and execution parameters. These include DELIVERY_ID and DELIVERY_DETAIL_ID, linking the batch to its parent delivery and specific delivery lines. The TRIP_ID and TRIP_STOP_ID associate the batch with a specific freight shipment and the stop sequence for pickup. Furthermore, the table holds rule identifiers (PICK_GROUPING_RULE_ID and PICK_SEQUENCE_RULE_ID) that determine how lines were grouped into the batch and the recommended sequence for picking, respectively. This structure captures the complete lifecycle of a batch from its rule-based creation to its assignment for physical execution.

Common Use Cases and Queries

This table is central to reporting and troubleshooting the pick release and picking processes. Common use cases include analyzing batch composition, tracking batch status, and identifying bottlenecks. A typical query might join WSH_PICKING_BATCHES to WSH_NEW_DELIVERIES and WSH_DELIVERY_DETAILS to list all batches for a specific order or item. For warehouse performance analysis, one could query batches by PICK_GROUPING_RULE_ID to assess the effectiveness of different grouping strategies. Support and development personnel frequently query this table to diagnose issues where delivery lines are not appearing in expected picking waves or to trace the shipping progress of a batch from the warehouse to its assigned trip.

Related Objects

The WSH_PICKING_BATCHES table maintains integral relationships with several other WSH tables, as documented in its foreign keys. It is a child table to WSH_NEW_DELIVERIES and WSH_DELIVERY_DETAILS, linking batches to the shipping document. Its relationship with WSH_TRIPS and WSH_TRIP_STOPS connects the picking operation to transportation planning. The dependencies on WSH_PICK_GROUPING_RULES and WSH_PICK_SEQUENCE_RULES tie batch creation to configurable warehouse rules. For programmatic access and business logic, key related APIs include the Pick Release concurrent program and the `WSH_PICKING_BATCHES_PUB` package. The primary key constraint WSH_PICKING_BATCHES_PK enforces data integrity for the BATCH_ID column.