Search Results wsh_pick_slip_rules




Overview
Explore in AI Chat

Overview

The WSH_PICK_SLIP_RULES table is a core data object within the Oracle E-Business Suite (EBS) Order Entry (OE) and Shipping Execution modules. It serves as the master repository for defining and storing the rules that govern the generation and formatting of pick slips. These rules are critical for warehouse operations, as they determine the content, layout, and grouping logic for pick slips, which are the primary documents used by warehouse personnel to fulfill customer orders. The table's role is to provide a centralized definition that can be associated with specific picking batches or picking rules, thereby standardizing and automating the picking documentation process across the organization.

Key Information Stored

The primary data stored in this table centers on the unique identification and definition of each pick slip rule. The key column is PICK_SLIP_RULE_ID, which serves as the primary key and unique identifier for each rule definition. While the provided ETRM metadata does not list all columns, the table's purpose implies it would store attributes that define the rule's behavior. These typically include the rule name, descriptions, and various flags or parameters controlling aspects such as the inclusion of item details, lot/serial numbers, shipping instructions, and the grouping of lines (e.g., by order, ship-to location, or item). The rule definitions act as templates referenced during the pick slip generation process.

Common Use Cases and Queries

The primary use case is the configuration and assignment of pick slip formatting rules to picking batches. An administrator defines a rule in the application interface, which creates a record in this table. This rule is then selected when creating a picking batch or a picking rule. Common reporting and validation queries involve joining this table to its related entities. For instance, to list all defined pick slip rules, a simple SELECT statement on the primary columns is used. A more complex query would join WSH_PICK_SLIP_RULES to SO_PICKING_BATCHES_ALL to identify which rule is applied to a specific batch or to audit rule usage across active picking workloads. Troubleshooting often involves verifying the existence and details of a rule referenced by a problematic batch.

Related Objects

As indicated by the foreign key constraints in the metadata, the WSH_PICK_SLIP_RULES table has direct relationships with two key tables in the Order Management module. The SO_PICKING_BATCHES_ALL table references it via the PICK_SLIP_RULE_ID column, linking a specific picking batch to the pick slip format it should use. Similarly, the SO_PICKING_RULES table references it, allowing picking rules (which define selection criteria for creating batches) to also specify a default pick slip output format. These relationships underscore the table's integral position in the order fulfillment flow, bridging the configuration of picking logic with the physical documentation required for execution.