Results for “arrow_geometry”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

WF_ACTIVITY_TRANSITIONS is a core configuration table in the Oracle E-Business Suite Workflow (WF) engine, owned by the APPLSYS schema and registered under the FND – Application Object Library product. It stores the transition definitions that govern how a workflow process moves from one activity to the next. In workflow terminology, a transition is a directed edge: when a given activity produces a particular result, the engine consults this table to determine which downstream activity should be executed next. Without rows in WF_ACTIVITY_TRANSITIONS, a workflow process would have activities that could never route onward, making this table one of the fundamental building blocks of process navigation.

From a data modeling perspective, the ETRM metadata classifies this object heuristically as a link table. This suggestion is well founded: each row associates a source activity with a target activity through a result code, effectively resolving a many-to-many relationship between WF_PROCESS_ACTIVITIES rows. The link classification reflects the table's role as a connector or join structure rather than a descriptive hub or a slowly changing satellite.

Key Information Stored

The table contains eight documented columns in the 12.2.2 physical schema. The most significant are the three that form the composite primary key, WF_ACTIVITY_TRANSITIONS_PK, and which also constitute the business-key candidate surfaced through the unique index (extended in the documented schema with ZD_EDITION_NAME):

• FROM_PROCESS_ACTIVITY – the originating activity in the transition. This is a foreign key to WF_PROCESS_ACTIVITIES and defines the source node of the edge.
• RESULT_CODE – the outcome produced by the source activity (for example, a standard result such as a completion, approval, or rejection code). It functions as the discriminator that determines which branch is taken.
• TO_PROCESS_ACTIVITY – the destination activity, also a foreign key to WF_PROCESS_ACTIVITIES, defining the target node of the edge.
• PROTECT_LEVEL and CUSTOM_LEVEL – customization and protection indicators that control whether Oracle or the customer may modify the transition definition, consistent with standard EBS customization-governance columns.
• ARROW_GEOMETRY – display metadata used by the Workflow Builder graphical designer to render the arrow graphically connecting the two activities.
• SECURITY_GROUP_ID – a foreign key to FND_SECURITY_GROUPS, enforcing the security grouping that isolates data across environments and business groups.
• ZD_EDITION_NAME – the editioning column supporting Online Patching in 12.2.x, allowing transitions to be defined and modified in an edition-safe manner.

Note that there is no separate single-column surrogate key; the primary identifier is the composite of FROM_PROCESS_ACTIVITY, RESULT_CODE, and TO_PROCESS_ACTIVITY. The composite unique index serves as the business-key candidate.

Common Use Cases and Queries

The primary use case is workflow engine navigation and process definition validation. Developers and analysts frequently query this table to enumerate the routing logic of a process, to trace reachable activities, or to diagnose stuck workflows caused by a missing transition. A representative query lists all transitions for a given process by joining to WF_PROCESS_ACTIVITIES:

• SELECT from_activity.name, t.result_code, to_activity.name FROM wf_activity_transitions t, wf_process_activities from_activity, wf_process_activities to_activity WHERE t.from_process_activity = from_activity.instance_id AND t.to_process_activity = to_activity.instance_id;
• Reporting on orphaned transitions where FROM_PROCESS_ACTIVITY or TO_PROCESS_ACTIVITY does not resolve to an existing activity, indicating corrupt or incomplete process definitions.
• Auditing customization exposure by filtering on PROTECT_LEVEL and CUSTOM_LEVEL to detect transitions modified or protected outside standard Oracle definitions.

Related Objects

The most significant related objects are those joined through the documented foreign keys:

• WF_PROCESS_ACTIVITIES – referenced twice, via FROM_PROCESS_ACTIVITY and TO_PROCESS_ACTIVITY; the parent activity instances for both ends of each transition.
• WF_PROCESS_ACTIVITIES_PK – the primary key of the parent activity table, joined to both activity columns.
• FND_SECURITY_GROUPS – referenced via SECURITY_GROUP_ID, enforcing environment and business-group isolation.
• WF_ACTIVITIES and WF_PROCESSES – the activity and process definition tables that ultimately contextualize the transitions.
• Workflow Builder (WFBLDR) – the graphical design tool that reads and writes ARROW_GEOMETRY and transition rows.
• WF_ENGINE APIs – the runtime engine that consumes transition definitions to route process execution.