Results for “wf_process_activities_u2”
10 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPLSYS.WF_PROCESS_ACTIVITIES is a core Oracle Workflow seed table that stores the definition of an individual activity as it appears within a specific process. Whereas WF_ACTIVITIES defines an activity in the abstract, WF_PROCESS_ACTIVITIES binds that activity to a concrete process (identified by item type, name, and version) and captures the process-specific attributes required at runtime and in the Workflow Builder diagram — placement of the icon, the default result, the performing role, and whether the node is a start or end activity.
The object is owned by APPLSYS, is backed by FND design data (FND.WF_PROCESS_ACTIVITIES), and resides in the APPS_TS_SEED tablespace. It carries a status of VALID in both 12.1.1 and 12.2.2. Under the heuristic Data Vault classification mined from the foreign-key structure, this table is best modeled as a hub: it holds the durable business key of a process-activity instance and is referenced by several surrounding tables rather than being a pure transaction log. This classification is a modeling suggestion only; the physical object remains a standard EBS seed table with edition-based redefinition support.
Key Information Stored
The most significant columns are those that describe the process context and the activity instance:
- PROCESS_ITEM_TYPE, PROCESS_NAME, PROCESS_VERSION — the composite identifier of the owning process.
- ACTIVITY_ITEM_TYPE, ACTIVITY_NAME — the item type and internal name of the activity being placed within that process.
- INSTANCE_ID — a surrogate identifying an activity that is used more than once inside a process; this column anchors the primary key WF_PROCESS_ACTIVITIES_PK.
- INSTANCE_LABEL — the unique display name for the activity within the process.
- PERFORM_ROLE_TYPE, PERFORM_ROLE — whether the performing role is a constant or an attribute, and the role assigned to receive the notification.
- START_END — flags whether the node is a Start or End activity.
- DEFAULT_RESULT — the result returned when no result is supplied.
- PROTECT_LEVEL, CUSTOM_LEVEL — the protection level of the seed data and the customization level of the last updater.
- ICON_GEOMETRY — diagram placement coordinates used by Workflow Builder.
- SECURITY_GROUP_ID, ZD_EDITION_NAME — hosting-environment identifier and editioning discriminator.
Two unique indexes act as business-key candidates: WF_PROCESS_ACTIVITIES_PK on (INSTANCE_ID, ZD_EDITION_NAME), and WF_PROCESS_ACTIVITIES_U2 on (INSTANCE_LABEL, PROCESS_ITEM_TYPE, PROCESS_NAME, PROCESS_VERSION, ZD_EDITION_NAME) — the latter is the natural key that the user search "wf_process_activities_u2" refers to. Non-unique indexes N1 (ACTIVITY_ITEM_TYPE, ACTIVITY_NAME) and N2 (PROCESS_ITEM_TYPE, PROCESS_NAME, PROCESS_VERSION) support reverse lookups.
Common Use Cases and Queries
Typical scenarios include auditing which activities belong to a given process version, locating the performing role for a notification, and exporting workflow diagram geometry. The natural key index U2 is the most efficient access path when reconciling seed data across environments.
- List all activities in a process:
SELECT INSTANCE_LABEL, ACTIVITY_NAME, START_END FROM WF_PROCESS_ACTIVITIES WHERE PROCESS_ITEM_TYPE = :p AND PROCESS_NAME = :n AND PROCESS_VERSION = :v; - Find where an activity is used: join on WF_PROCESS_ACTIVITIES_N1 by ACTIVITY_ITEM_TYPE and ACTIVITY_NAME.
- Resolve the notification role: select PERFORM_ROLE_TYPE and PERFORM_ROLE for a specific INSTANCE_LABEL.
- Verify seed integrity: query WF_PROCESS_ACTIVITIES_U2 columns to detect duplicate labels after a patch.
Related Objects
- WF_ACTIVITIES — referenced via PROCESS_ITEM_TYPE/ACTIVITY_ITEM_TYPE; the definition source.
- FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID.
- WF_ACTIVITY_ATTR_VALUES — joins on PROCESS_ACTIVITY_ID.
- WF_ACTIVITY_TRANSITIONS — joins on FROM_PROCESS_ACTIVITY and TO_PROCESS_ACTIVITY.
- WF_ITEM_ACTIVITY_STATUSES — joins on PROCESS_ACTIVITY for runtime status.
- WF_ITEM_ACTIVITY_STATUSES_H — history counterpart joining on PROCESS_ACTIVITY.
-
Activity data within a process
-
Activity data within a process
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
eTRM - FND Tables and Views 12.2.2
No longer used
-
eTRM - FND Tables and Views 12.1.1
No longer used