Search Results carrier_flag




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

WSH_PICK_SLIP_RULES is a configuration table owned by the OE schema in Oracle E-Business Suite. It stores user-defined pick slip grouping rules that the Warehouse Management (WSH) picking engine applies during pick release and pick slip generation. Each row defines a named rule that instructs the system how to organize released sales order lines onto pick slips — for example, grouping lines by order number, subinventory, customer, ship-to location, carrier, shipment priority, departure, or delivery. The table therefore acts as the master repository of pick slip rule definitions referenced by picking batches and picking rule configurations.

From a dimensional modeling perspective, the ETRM metadata classifies this object heuristically as hub-leaning in a Data Vault model. This is a suggestion rather than a documented classification: the table holds stable, uniquely identified reference entities (business keys), which aligns with the characteristics of a hub, with the flag columns acting as descriptive attributes that could be modeled as satellites.

Key Information Stored

The table contains 38 documented columns. The surrogate primary key is PICK_SLIP_RULE_ID, enforced through the WSH_PICK_SLIP_RULES_PK constraint and mirrored by the unique index WSH_PICK_SLIP_RULES_U1, which serves as the business-key candidate. The most operationally significant columns are:

Common Use Cases and Queries

The primary use case is configuring how pick slips are consolidated during pick release. Administrators create and maintain rules in the shipping transaction and warehouse management setup windows; the rules are then assigned to orders or picking batches and consumed by the pick release process. Reporting scenarios include auditing which grouping attributes are enabled for each rule, verifying active versus expired rules, and tracing which batches or orders were generated under a given rule.

A typical query lists active rules and their enabling flags:

  • SELECT pick_slip_rule_id, name, order_number_flag, subinventory_flag, customer_flag, carrier_flag, shipment_priority_flag FROM wsh_pick_slip_rules WHERE SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE+1);

To trace usage, join to the dependent tables referenced by the documented foreign keys, such as SO_PICKING_BATCHES_ALL and SO_PICKING_RULES, on PICK_SLIP_RULE_ID. A further query joins WSH_PARAMETERS to identify the default rule configured for the warehouse parameters.

Related Objects

Several objects reference WSH_PICK_SLIP_RULES through the PICK_SLIP_RULE_ID column, and these relationships define the pick release configuration chain:

  • SO_PICKING_BATCHES_ALL — picking batches; joined on SO_PICKING_BATCHES_ALL.PICK_SLIP_RULE_ID = WSH_PICK_SLIP_RULES.PICK_SLIP_RULE_ID.
  • SO_PICKING_RULES — picking rule definitions; joined on SO_PICKING_RULES.PICK_SLIP_RULE_ID = WSH_PICK_SLIP_RULES.PICK_SLIP_RULE_ID.
  • WSH_PARAMETERS — warehouse parameters referencing the default pick slip rule via PICK_SLIP_RULE_ID.

These foreign-key relationships establish WSH_PICK_SLIP_RULES as the hub of a hub-and-link configuration structure, with batches, rules, and parameters acting as dependent links that consume its business key.