Search Results wsh_pick_grouping_rules




Overview
Explore in AI Chat

Overview

The WSH_PICK_GROUPING_RULES table is a core data object within the Oracle E-Business Suite Shipping Execution (WSH) module. It serves as the master repository for defining and storing the rules that govern how delivery lines are grouped together during the Pick Release process. These rules are critical for warehouse efficiency, as they determine the logical organization of work, such as creating picking batches based on criteria like ship-from location, order type, or customer. The table's primary identifier, PICK_GROUPING_RULE_ID, is referenced throughout the shipping workflow to enforce the configured grouping logic when releasing orders for picking.

Key Information Stored

The table's structure is centered on the unique identification and definition of each grouping rule. The most critical column is the PICK_GROUPING_RULE_ID, which serves as the primary key and unique sequence identifier for each rule record. While the provided ETRM metadata does not list all columns, typical columns in such a rule definition table would include a NAME or DESCRIPTION for the rule, ENABLED_FLAG to control active status, and various attribute columns that define the grouping criteria (e.g., grouping by inventory organization, subinventory, or project). The existence of a primary key constraint (WSH_PICK_GROUPING_RULES_PK) on PICK_GROUPING_RULE_ID ensures data integrity and is essential for foreign key relationships.

Common Use Cases and Queries

The primary use case is the configuration and application of grouping logic during Pick Release. An administrator may query the table to audit or report on existing rules. Common SQL patterns include fetching all active rules or finding the specific rule applied to a particular picking batch. For example, to link a picking batch to its grouping rule definition, a query would join WSH_PICKING_BATCHES to WSH_PICK_GROUPING_RULES using the PICK_GROUPING_RULE_ID. Troubleshooting often involves verifying which rule ID is assigned to a problematic batch or picking rule setup.

  • Listing all defined pick grouping rules: SELECT pick_grouping_rule_id, name FROM wsh_pick_grouping_rules WHERE enabled_flag = 'Y';
  • Finding the grouping rule for a specific picking batch: SELECT b.name batch_name, g.* FROM wsh_picking_batches b, wsh_pick_grouping_rules g WHERE b.pick_grouping_rule_id = g.pick_grouping_rule_id AND b.batch_id = :batch_id;

Related Objects

As indicated by the foreign key metadata, the PICK_GROUPING_RULE_ID column is a key reference point for other major shipping tables. The WSH_PICKING_BATCHES table stores a foreign key to this table, linking each physical or logical picking batch to the grouping rule that dictated its creation. Similarly, the WSH_PICKING_RULES table references it, allowing a picking rule (which defines release criteria) to be associated with a specific grouping rule. This relationship ensures that the grouping logic is an integral part of the broader pick release configuration. These dependencies underscore that WSH_PICK_GROUPING_RULES is a control table, with its identifier propagated to transactional entities.