Search Results wms_rule_consistencies_pk

Overview

The WMS_RULE_CONSISTENCIES table is a core data structure within the Oracle E-Business Suite Warehouse Management (WMS) module for versions 12.1.1 and 12.2.2. It functions as a junction or intersection table, establishing and enforcing the permissible relationships between warehouse rules and their associated parameters. This table is fundamental to the rule-based engine that drives configurable warehouse operations, ensuring that only valid parameter values can be assigned to specific rules, thereby maintaining data integrity and system consistency. Its role is to act as a constraint and definition layer between the master rule definitions and the master parameter definitions.

Key Information Stored

The table's primary purpose is to store associations, with its key columns serving as foreign keys to related master tables. The CONSISTENCY_ID column serves as the unique primary key for each valid rule-parameter combination. The RULE_ID column references a specific warehouse rule defined in the WMS_RULES_B table, such as a picking, putaway, or cycle counting rule. The PARAMETER_ID column references a configurable parameter defined in the WMS_PARAMETERS_B table, which could include values like a subinventory, locator, or item range. Together, a record in this table signifies that a given parameter is applicable and allowed for configuration within a specific rule.

Common Use Cases and Queries

A primary use case is the validation performed by the WMS user interface or APIs when a user configures a rule. The system queries this table to present only valid parameters for selection. Database administrators and functional consultants often query this table to audit or troubleshoot rule setups. A common diagnostic query is to list all parameters available for a specific rule, which assists in understanding system behavior or identifying missing configurations.

• To find all parameters for a specific rule by name:
  SELECT p.PARAMETER_NAME FROM WMS_RULE_CONSISTENCIES c, WMS_RULES_B r, WMS_PARAMETERS_B p WHERE c.RULE_ID = r.RULE_ID AND c.PARAMETER_ID = p.PARAMETER_ID AND r.RULE_NAME = '<RULE_NAME>';
• To identify rules that use a specific parameter:
  SELECT r.RULE_NAME FROM WMS_RULE_CONSISTENCIES c, WMS_RULES_B r WHERE c.RULE_ID = r.RULE_ID AND c.PARAMETER_ID = (SELECT PARAMETER_ID FROM WMS_PARAMETERS_B WHERE PARAMETER_NAME='<PARAM_NAME>');

Related Objects

The WMS_RULE_CONSISTENCIES table maintains documented foreign key relationships with two primary master tables, as confirmed by the provided ETRM metadata.

• WMS_RULES_B: This is the base table for warehouse rule definitions. The relationship is defined as WMS_RULE_CONSISTENCIES.RULE_ID → WMS_RULES_B. This ensures every consistency record points to a valid, existing rule.
• WMS_PARAMETERS_B: This is the base table for configurable parameter definitions. The relationship is defined as WMS_RULE_CONSISTENCIES.PARAMETER_ID → WMS_PARAMETERS_B. This ensures every consistency record points to a valid, existing system parameter.

These relationships are critical for referential integrity. The table itself is referenced by the primary key constraint WMS_RULE_CONSISTENCIES_PK on the CONSISTENCY_ID column.