Search Results so_picking_rules




Overview
Explore in AI Chat

Overview

The SO_PICKING_RULES table is a core data object within the Oracle E-Business Suite (EBS) Order Entry (OE) module, specifically for versions 12.1.1 and 12.2.2. It functions as a repository for pre-defined sets of picking parameters, often referred to as pick release rules. Its primary role is to streamline and standardize the order fulfillment process by storing frequently used configurations for the "Pick Release" transaction. This allows users to select a named rule during sales order entry or pick release, rather than manually specifying numerous picking criteria each time, thereby enhancing operational efficiency and consistency.

Key Information Stored

The table stores a unique identifier for each rule set and foreign key references to the specific parameters that constitute the rule. Based on the documented foreign key relationships, the table links to critical master and transactional data. The PICKING_RULE column itself holds the name of the rule set. The table's structure indicates it stores references to parameters such as the applicable Order Type (ORDER_TYPE_ID), Customer and Ship-to Site (CUSTOMER_ID, SITE_USE_ID), the grouping logic for pick slips (PICK_SLIP_RULE_ID), the sequencing logic for releasing lines (RELEASE_SEQ_RULE_SET_ID), and an associated Item Group (GROUP_ID). The HEADER_ID foreign key suggests rules can also be associated with specific sales orders, though the primary use is for reusable templates.

Common Use Cases and Queries

A primary use case is the rapid configuration of the Pick Release concurrent program. Users select a pre-defined picking rule to automatically apply criteria like release sequence, grouping method, and applicable orders. For reporting and administration, common SQL queries involve listing all defined rules and their components. For instance, to audit rule definitions, one might join to related master tables:

  • SELECT pr.picking_rule, ot.name order_type, c.customer_name FROM oe.so_picking_rules pr, so_order_types_tl ot, ra_customers c WHERE pr.order_type_id = ot.order_type_id AND pr.customer_id = c.customer_id(+);

Another critical use case is troubleshooting pick release issues by verifying the rule parameters applied to a specific sales order, joining SO_PICKING_RULES to SO_HEADERS_ALL via HEADER_ID.

Related Objects

The SO_PICKING_RULES table is centrally connected to several key EBS tables, primarily through foreign key relationships as documented in the ETRM. These relationships define its integration within the order-to-ship cycle:

  • SO_HEADERS_ALL: Links via SO_PICKING_RULES.HEADER_ID, allowing rules to be associated with specific sales orders.
  • WSH_RELEASE_SEQ_RULES: Links via SO_PICKING_RULES.RELEASE_SEQ_RULE_SET_ID to define the sequencing logic for releasing order lines to the warehouse.
  • SO_ORDER_TYPES_115_ALL: Links via SO_PICKING_RULES.ORDER_TYPE_ID to restrict the rule to a specific order type.
  • RA_CUSTOMERS & RA_SITE_USES_ALL: Link via CUSTOMER_ID and SITE_USE_ID to restrict the rule to a specific customer or ship-to address.
  • SO_ITEM_GROUPS: Links via GROUP_ID to apply the rule to a specific set of items.
  • WSH_PICK_SLIP_RULES: Links via PICK_SLIP_RULE_ID to define how picked lines are grouped on pick slips.