Results for “wf_item_attribute_values”

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

Overview

WF_ITEM_ATTRIBUTE_VALUES is a core Oracle Workflow configuration table residing in the APPLSYS schema and owned by the FND — Application Object Library product. It stores the actual data values assigned to attributes of workflow items. In the Oracle EBS workflow architecture, every runtime entity — a purchase order approval, a requisition, an expense report, or any custom business object participating in a workflow — is represented as an "item" of a given item type. Attributes describe those items, and WF_ITEM_ATTRIBUTE_VALUES holds the concrete value each item carries for each named attribute.

From a Data Vault modeling perspective, this table is best classified as a link (heuristic, mined from its foreign key structure). Its composite key connects three dimensions: the item (via WF_ITEMS), the attribute definition (via WF_ITEM_ATTRIBUTES), and the value. It should therefore be modeled as a relationship table rather than as a standalone hub or satellite.

Key Information Stored

The table is defined with nine columns in the documented 12.2.2 physical schema. The most significant are:

• ITEM_TYPE — Identifies the workflow item type (for example, a seeded type such as POAPPRV or a custom type). Part of both foreign keys to WF_ITEMS and WF_ITEM_ATTRIBUTES.
• ITEM_KEY — The unique identifier of the individual workflow item within the item type. Together with ITEM_TYPE it resolves the owning WF_ITEMS row.
• NAME — The internal name of the attribute whose value is stored, resolving to the defining row in WF_ITEM_ATTRIBUTES.
• TEXT_VALUE — Character value for attributes defined with a text data type.
• NUMBER_VALUE — Numeric value for attributes defined with a number data type.
• DATE_VALUE — Date value for attributes defined with a date data type.
• EVENT_VALUE — Event or callback value for attributes defined as event types.
• SECURITY_GROUP_ID — References FND_SECURITY_GROUPS and governs multi-organization / security-group visibility.
• INST_ID — Install identifier column, used in multi-instance and data-synchronization scenarios.

The surrogate-side primary key constraint is WF_ITEM_ATTRIBUTE_VALUES_PK, whose business-key columns are ITEM_TYPE, ITEM_KEY, NAME. This same column combination is the significant unique index; the remaining unique indexes (SYS_IL0000035160C00012$$, SYS_IL0000035160C00015$$) are internal LOB indexes and carry no business meaning. Correct interpretation of a row therefore requires reading the attribute definition to know which of the four typed value columns is authoritative.

Common Use Cases and Queries

Typical use cases include troubleshooting stalled or erroneous workflow processes, auditing approval routing, and building operational reports over in-flight workflow items.

• Retrieving all attribute values for a specific item:

  SELECT name, text_value, number_value, date_value
  FROM   applsys.wf_item_attribute_values
  WHERE  item_type = :p_item_type
  AND    item_key  = :p_item_key;

• Resolving the label and data type of each value by joining to the attribute definition:

  SELECT v.name, a.display_name, a.type,
         v.text_value, v.number_value, v.date_value
  FROM   applsys.wf_item_attribute_values v,
         applsys.wf_item_attributes      a
  WHERE  v.item_type = a.item_type
  AND    v.name      = a.name
  AND    v.item_key  = :p_item_key;

• Cross-item reporting, for example locating every item whose named attribute matches a value:

  SELECT item_type, item_key, text_value
  FROM   applsys.wf_item_attribute_values
  WHERE  name       = 'APPROVAL_STATUS'
  AND    text_value  = 'REJECTED';

Direct DML against this table is generally discouraged; values are maintained by workflow APIs and the Workflow Engine. Security-group restrictions should be applied in multi-org environments.

Related Objects

• WF_ITEMS — Parent of each item; joined on ITEM_TYPE and ITEM_KEY. Supplies item display name, owner role, and end date.
• WF_ITEM_ATTRIBUTES — Defines each attribute; joined on ITEM_TYPE and NAME. Provides data type, display name, and attribute properties.
• FND_SECURITY_GROUPS — Referenced by SECURITY_GROUP_ID for row-level security grouping.
• WF_ITEM_ATTRIBUTE_VALUES_PK — Unique constraint enforcing one value per attribute per item.
• WF_ITEM_TYPES and WF_PROCESS_ACTIVITIES — Define the process context in which items and their attributes participate.
• Workflow Engine APIs (such as WF_ENGINE.SetItemAttrText, SetItemAttrNumber, SetItemAttrDate, and their Get equivalents) — the supported programmatic interface for reading and writing values.