Search Results wf_routing_rule_attributes




Overview
Explore in AI Chat

Overview

The WF_ROUTING_RULE_ATTRIBUTES table is a core data object within the Oracle E-Business Suite (EBS) Application Object Library (FND) module. It functions as the repository for the specific attributes that define the conditions and parameters of notification routing rules. These rules are a fundamental component of the Oracle Workflow engine, governing the dynamic assignment and escalation of workflow notifications to users or roles based on runtime data. The table's existence is critical for enabling sophisticated, data-driven business process automation within EBS applications such as Oracle Purchasing, Oracle Payables, and Oracle Human Resources, where approval routing must adapt to complex organizational hierarchies and business conditions.

Key Information Stored

The table stores the individual attributes that comprise a routing rule. Its structure is defined by a composite primary key consisting of RULE_ID, NAME, and TYPE, ensuring uniqueness for each attribute within a rule. The RULE_ID column is a foreign key that links the attribute to its parent rule definition in the WF_ROUTING_RULES table. The NAME column identifies the specific attribute, which typically corresponds to an item type attribute from the associated workflow process. The TYPE column classifies the attribute, such as indicating if it holds a constant value, a lookup code, or a PL/SQL expression. Additional columns, inferred from standard Oracle Workflow patterns, would store the attribute's actual VALUE, and potentially a DISPLAY_NAME for user interfaces. This design allows a single routing rule to be parameterized with multiple runtime criteria.

Common Use Cases and Queries

This table is primarily accessed by the Oracle Workflow engine during notification processing to evaluate routing rule conditions. Common administrative and reporting tasks involve analyzing or troubleshooting rule definitions. A typical query retrieves all attributes for a specific rule to understand its logic:

  • SELECT name, type, value FROM apps.wf_routing_rule_attributes WHERE rule_id = <RULE_ID> ORDER BY name;

Another common use case is identifying all rules that reference a particular item attribute, which is useful for assessing the impact of changes to a workflow process:

  • SELECT DISTINCT r.rule_id, r.name FROM apps.wf_routing_rules r, apps.wf_routing_rule_attributes a WHERE r.rule_id = a.rule_id AND a.name = '<ATTRIBUTE_NAME>';

Direct data manipulation (DML) on this table is strongly discouraged; rule creation and modification should be performed via the Oracle Workflow Builder or supported administrative APIs.

Related Objects

The WF_ROUTING_RULE_ATTRIBUTES table has a direct and essential relationship with the WF_ROUTING_RULES table, as enforced by its foreign key constraint. The RULE_ID column references WF_ROUTING_RULES.RULE_ID, linking attributes to their parent rule definition. These two tables, along with WF_ROUTING_RULE_FUNCTIONS, form the core data model for stored routing rules. The rules and their attributes are utilized by the Workflow Engine's internal procedures and are often accessed via public Workflow APIs. While not a direct foreign key relationship, the attribute NAME often correlates with item type attributes defined within the WF_ITEM_ATTRIBUTES and WF_ITEM_ATTRIBUTE_VALUES tables for the relevant workflow process.