Search Results wf_activity_attr_values_pk




Overview
Explore in AI Chat

Overview

The WF_ACTIVITY_ATTR_VALUES table is a core data repository within the Oracle Workflow engine of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. Owned by the APPLSYS schema and part of the Application Object Library (FND) module, it functions as the persistent store for runtime values assigned to activity attributes. In Oracle Workflow, an activity (a unit of work) can have associated attributes that act as parameters or variables. This table holds the specific, instance-level data for those attributes as a workflow process executes, enabling dynamic behavior, data passing between process steps, and state management. Its role is critical for the runtime execution and persistence of workflow process logic.

Key Information Stored

The table's structure is designed to associate attribute values with specific instances of activities within a running workflow process. The primary key, WF_ACTIVITY_ATTR_VALUES_PK, is a composite key on PROCESS_ACTIVITY_ID and NAME, ensuring unique value storage per attribute per activity instance. Key columns include PROCESS_ACTIVITY_ID, which links to a specific instance of an activity in the WF_PROCESS_ACTIVITIES table. The NAME column stores the identifier of the activity attribute as defined in the workflow's metadata. The VALUE column holds the actual runtime data for the attribute, which can be text, numbers, or dates. Additional columns typically include TYPE to indicate the data type of the value and TEXT_VALUE for longer text storage, though these are inferred from standard implementation patterns.

Common Use Cases and Queries

A primary use case is debugging or auditing a workflow instance to inspect the data state at various activities. Developers and administrators query this table to understand why a process branched a certain way or to verify input values. Another common scenario is custom reporting on workflow execution history, extracting business data passed through attributes. A sample query to retrieve all attribute values for a specific process activity instance would be:

  • SELECT NAME, VALUE, TYPE FROM APPLSYS.WF_ACTIVITY_ATTR_VALUES WHERE PROCESS_ACTIVITY_ID = <instance_id> ORDER BY NAME;

For troubleshooting, a join to WF_PROCESS_ACTIVITIES and WF_ITEMS can trace values back to the overall workflow item:

  • SELECT wiav.name, wiav.value, wpa.instance_label FROM wf_activity_attr_values wiav, wf_process_activities wpa WHERE wiav.process_activity_id = wpa.instance_id AND wpa.process_item_key = '<item_key>';

Related Objects

The table maintains a fundamental foreign key relationship with the WF_PROCESS_ACTIVITIES table, which is documented in the provided metadata. The relationship is defined as:

  • Foreign Key from WF_ACTIVITY_ATTR_VALUES to WF_PROCESS_ACTIVITIES: The column WF_ACTIVITY_ATTR_VALUES.PROCESS_ACTIVITY_ID references the WF_PROCESS_ACTIVITIES table. This enforces that every stored attribute value is associated with a valid, running activity instance.

This table is also intrinsically related to the WF_ACTIVITY_ATTRIBUTES table, which stores the metadata definition (name, type, default) of attributes for an activity type. At runtime, WF_ACTIVITY_ATTR_VALUES stores the concrete instances of those definitions. The table is commonly accessed via the Oracle Workflow PL/SQL APIs rather than through direct DML.