Results for “wf_activity_attr_values”

50+ results




Overview
Explore in AI Chat

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

Overview

WF_ACTIVITY_ATTR_VALUES is a core configuration table in the Oracle E-Business Suite Workflow (WF) schema, owned by APPLSYS and registered under the FND - Application Object Library product. It stores the values assigned to attributes of workflow activities, which are the discrete process steps executed within an Oracle Workflow process definition. Each row binds a named attribute to a specific activity instance, enabling the Workflow engine to carry configuration data, runtime parameters, and message attribute bindings through the lifecycle of a business process.

From a modeling perspective, the heuristic Data Vault classification supplied in the ETRM metadata is satellite-leaning. This reflects the table's structure: rows are keyed by a parent activity identifier plus an attribute name, and the primary payload consists of descriptive value columns rather than independent entity identity. In Data Vault terms, the table behaves as a satellite hanging off the WF_PROCESS_ACTIVITIES hub (or link), tracking attribute values that describe that parent activity.

Key Information Stored

The documented physical schema contains ten columns, of which the following are most significant:

  • PROCESS_ACTIVITY_ID — The foreign key to WF_PROCESS_ACTIVITIES identifying the parent activity whose attribute is being valued. This is a business-key component of the primary key.
  • NAME — The attribute name (for example, a message attribute or activity property). Combined with PROCESS_ACTIVITY_ID it forms the WF_ACTIVITY_ATTR_VALUES_PK primary key.
  • VALUE_TYPE — Indicates the data type of the stored value (text, number, or date), guiding which of the typed value columns is authoritative.
  • TEXT_VALUE — The textual representation of the attribute value when the attribute is character-typed.
  • NUMBER_VALUE — The numeric representation of the attribute value for numeric attributes.
  • DATE_VALUE — The date representation of the attribute value for date-typed attributes.
  • PROTECT_LEVEL — Access protection level controlling who may read or modify the row.
  • CUSTOM_LEVEL — Indicates the customization tier (for example, core versus customer-modified) applied to the attribute value.
  • SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, scoping the row to a security group.
  • ZD_EDITION_NAME — The editioning column introduced under Oracle EBS 12.2's Online Patching (ADOP) architecture. It is included in the unique index WF_ACTIVITY_ATTR_VALUES_PK (PROCESS_ACTIVITY_ID, NAME, ZD_EDITION_NAME), which is the business-key candidate in 12.2.2.

The surrogate primary key, WF_ACTIVITY_ATTR_VALUES_PK, is therefore composite and business-derived rather than a synthesized sequence: it pairs the activity identifier with the attribute name (plus the edition name in 12.2.x).

Common Use Cases and Queries

Typical uses include diagnosing why a workflow notification fails to fire, auditing attribute values attached to a specific activity, and reporting on customized (CUSTOM_LEVEL) activity properties prior to an upgrade or patch.

A common join pattern retrieves the value of a named attribute for a given activity:

  • SELECT a.name, v.value_type, v.text_value, v.number_value, v.date_value FROM wf_activity_attr_values v, wf_process_activities a WHERE v.process_activity_id = a.process_activity_id AND a.process_item_id = :item_id AND v.name = :attr_name;

To audit all attributes defined on a parent activity, filter on PROCESS_ACTIVITY_ID and order by NAME. To identify customer-modified attribute values, filter on CUSTOM_LEVEL. Reporting against SECURITY_GROUP_ID supports security-scoped extraction for multi-org or multi-group deployments.

Related Objects

  • WF_PROCESS_ACTIVITIES — The parent table; joined on WF_ACTIVITY_ATTR_VALUES.PROCESS_ACTIVITY_ID = WF_PROCESS_ACTIVITIES.PROCESS_ACTIVITY_ID. This is the primary FK relationship.
  • FND_SECURITY_GROUPS — Referenced via WF_ACTIVITY_ATTR_VALUES.SECURITY_GROUP_ID, providing the security grouping for each attribute value row.
  • WF_ACTIVITIES — Defines the catalog of activity definitions whose attributes are valued here.
  • WF_ITEM_ACTIVITY_STATUSES — Tracks runtime activity state for workflow items, frequently joined for diagnostics alongside attribute values.
  • WF_ACTIVITY_ATTRIBUTES — Defines the attribute metadata (type, default) that WF_ACTIVITY_ATTR_VALUES populates with concrete values.
  • WF_PROCESSES / WF_ITEMS — Broader process and item context used when tracing an attribute value back to its executing instance.
  • WF_CORE Workflow Engine APIs — The runtime engine reads these values when executing activity steps and generating notifications.