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:

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