Search Results wf_route




Overview
Explore in AI Chat

Overview

The APPS.WF_ROUTE package is a core component of the Oracle Workflow engine, which underpins the routing and approval infrastructure used throughout Oracle E-Business Suite 12.1.1 and 12.2.2. Its principal business function is to manage routing rules — the configurable logic that determines how a workflow process instance transitions from one activity to the next. Routing rules are evaluated by the Workflow Engine at runtime, allowing administrators to redirect, skip, or branch process flow based on item attributes and business conditions without modifying the underlying process definition.

In addition to rule administration, the package exposes utility procedures dedicated to rendering and inspecting the Workflow notification "frames" — the standard HTML notification interface used for approval and FYI messages. It therefore serves two distinct roles: as a programmatic API for creating and maintaining routing rules, and as a presentation helper for the notification web pages.

Key Procedures and Functions

The ETRM metadata records 13 documented program units, classified generically as OTHER. Their functions can be summarized as follows:

  • CREATERULE1, CREATERULE2, CREATERULE3, and CREATERULE — overloaded entry points for defining new routing rules. The numbered variants accommodate different call signatures and rule configurations, while the generic CREATERULE provides the primary interface.
  • UPDATERULE — modifies the definition of an existing routing rule, such as its condition, activity target, or result type.
  • DELETERULE — removes a routing rule from a workflow process definition.
  • SUBMITCREATE and SUBMITUPDATE — submission wrappers that stage or invoke the create and update operations, typically within the context of the Workflow administration UI.
  • FIND — locates routing rules or associated configuration records based on supplied criteria.
  • CHANGEMESSAGENAME — alters the name associated with a workflow message, supporting notification customization.
  • LIST, LISTFRAME, and LISTBUTTON — rendering procedures that generate the HTML elements of the notification frame, including the list display, the frame wrapper, and the action buttons presented to the recipient.

No parameter lists are reproduced here, consistent with the documented metadata.

Tables Accessed

The package operates against the Workflow routing rule schema through APPS synonyms. WF_ROUTING_RULES and its shadow table WF_ROUTING_RULES_S hold the primary rule definitions, with the _S table supporting the seeded/upgradeable rule content. WF_ROUTING_RULE_ATTRIBUTES stores the item attributes against which a rule's condition is evaluated. WF_ITEM_ATTRIBUTES holds the runtime attribute values for active workflow items, which the engine compares during rule evaluation. The rendering procedures draw on the Oracle Web Toolkit packages HTF, HTP, and OWA_UTIL to emit HTML for the notification frame. The SYS.STANDARD dependency reflects normal PL/SQL runtime linkage.

Usage Notes

WF_ROUTE is most often invoked indirectly. The Workflow Builder and the Workflow Administrator responsibility use its create, update, and delete routines when a developer or administrator edits routing rules on a process definition. The list and frame procedures are exercised at runtime whenever the Notification System opens a notification page in a browser, making them part of the standard approval workflow experience rather than anything a developer calls directly.

Custom code should invoke the create, update, and delete routines with care, since routing rules are shared configuration and are frequently reloaded during patching and upgrades. The ETRM metadata indicates the package is referenced by no other APPS packages, confirming it is an application-level entry point rather than an internal building block. Any direct use should be validated against the EBS 12.1.1 or 12.2.2 code level in use, and, where possible, routing rule maintenance should be performed through the supported Workflow administration interfaces.