Search Results mtl_picking_rules




Overview
Explore in AI Chat

Overview

The MTL_PICKING_RULES table is a core data object within the Oracle E-Business Suite Inventory (INV) module. It serves as the master repository for defining picking rules, which are critical business logic components that govern the selection of subinventory and locator combinations during the fulfillment of sales orders, internal orders, and other material issues. These rules automate and standardize the picking process, ensuring that material is sourced according to predefined organizational policies, such as prioritizing certain subinventories or enforcing lot and serial control. Its role is integral to the pick release, pick slip generation, and shipping execution workflows in Oracle Order Management and Inventory.

Key Information Stored

While the provided metadata does not list specific columns, the table's primary purpose is to store picking rule definitions. Based on its function and primary key, the table typically contains the following key attributes: PICKING_RULE_ID (the unique identifier and primary key), a RULE_NAME for identification, and an ENABLED_FLAG to control active status. Crucially, it stores the rule's logic definition, which may include criteria for subinventory and locator selection, sequencing, and compatibility with lot and serial control. The table acts as a header, with its detailed sourcing criteria often stored in related child tables such as MTL_PICKING_RULE_LINES.

Common Use Cases and Queries

The primary use case is configuring and maintaining the sourcing logic for automated picking. Administrators create and assign rules at the organization level or item level. Common reporting and validation queries include listing all active picking rules or identifying the default rule for an organization. A typical SQL pattern joins MTL_PICKING_RULES with organizational parameters.

  • Identifying the default picking rule for an organization: SELECT mp.organization_code, mpr.picking_rule_id, mpr.rule_name FROM mtl_parameters mp, mtl_picking_rules mpr WHERE mp.default_picking_rule_id = mpr.picking_rule_id;
  • Finding items assigned a specific picking rule: SELECT msi.segment1 item_code, msi.description FROM mtl_system_items_b msi WHERE msi.picking_rule_id = <RULE_ID>;

Related Objects

The MTL_PICKING_RULES table has documented foreign key relationships with several fundamental Inventory tables, as per the provided metadata.

  • MTL_PARAMETERS: The column MTL_PARAMETERS.DEFAULT_PICKING_RULE_ID references MTL_PICKING_RULES.PICKING_RULE_ID. This establishes the organization-wide default picking rule.
  • MTL_SYSTEM_ITEMS_B: The column MTL_SYSTEM_ITEMS_B.PICKING_RULE_ID references MTL_PICKING_RULES.PICKING_RULE_ID. This allows a specific picking rule to be assigned directly to an item, overriding the organization default.
  • Child Tables: While not listed in the excerpt, implementation details typically involve related tables like MTL_PICKING_RULE_LINES and MTL_PICKING_RULE_DETAILS, which store the specific sourcing criteria (subinventory, locator, sequencing) for each rule.