Search Results wms_restrictions




Overview
Explore in AI Chat

Overview

The WMS_RESTRICTIONS table is a core data object within the Oracle E-Business Suite Warehouse Management (WMS) module. It functions as the detailed repository for the conditional logic that defines warehouse operational rules. Specifically, this table stores the individual restriction components or clauses that collectively form a complete business rule in WMS. Each row represents a single condition (e.g., Item = 'X', Subinventory = 'Y') that is evaluated during warehouse transactions such as putaway, picking, and replenishment. The table's role is to provide the granular, configurable constraints that enforce business policies on inventory movement and storage, enabling precise control over warehouse operations.

Key Information Stored

The table's structure is designed to define conditional statements. The primary key is a composite of RULE_ID and SEQUENCE_NUMBER, ensuring the order of multiple restrictions within a single rule is preserved. Critical columns include RULE_ID, which links the restriction to its parent rule defined in WMS_RULES_B; SEQUENCE_NUMBER, which dictates the evaluation order; and columns that define the condition's components. These typically include a PARAMETER_ID (e.g., Item, Subinventory) from WMS_PARAMETERS_B, an operator, and an operand value. The operand can be a fixed value or reference another parameter (OPERAND_PARAMETER_ID) or a flexfield value set (OPERAND_FLEX_VALUE_SET_ID), allowing for dynamic and flexible rule definitions.

Common Use Cases and Queries

This table is central to troubleshooting and analyzing warehouse rule behavior. Common use cases include auditing all restrictions attached to a specific rule to understand its full logic, or identifying which rules restrict activities for a particular item or subinventory. A typical analytical query joins WMS_RESTRICTIONS to WMS_RULES_B to get the rule context and to WMS_PARAMETERS_B (twice) to resolve the parameter and operand parameter names. For example, to find all rules restricting a specific item, one might query restrictions where the parameter corresponds to 'Item' and the operand value matches the item code. Reporting often focuses on generating a human-readable list of rule conditions for business process documentation.

Related Objects

The WMS_RESTRICTIONS table maintains integral relationships with several other WMS foundation tables, as documented by its foreign keys:

  • WMS_RULES_B: The primary parent table. The RULE_ID column in WMS_RESTRICTIONS references WMS_RULES_B.RULE_ID, linking each restriction clause to its overarching business rule.
  • WMS_PARAMETERS_B: Has two distinct foreign key relationships.
    • PARAMETER_ID references WMS_PARAMETERS_B.PARAMETER_ID to identify the main attribute of the condition (e.g., Item, Subinventory).
    • OPERAND_PARAMETER_ID references WMS_PARAMETERS_B.PARAMETER_ID to identify a second attribute used as the comparison value in the condition.
  • FND_FLEX_VALUE_SETS: OPERAND_FLEX_VALUE_SET_ID references FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_ID, allowing the restriction's operand to be validated against a predefined list of values from a descriptive flexfield.