Results for “wf_item_attributes”

50+ results




Overview
Explore in AI Chat

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

Overview

WF_ITEM_ATTRIBUTES is a foundational configuration table in the Oracle EBS Application Object Library (FND) schema, owned by APPLSYS. It stores the attribute definitions that describe the characteristics of every workflow item type registered in the Oracle Workflow engine. In Oracle EBS 12.1.1 and 12.2.2, workflow item types serve as the metadata containers for business objects such as requisitions, purchase orders, invoices, and concurrent programs. Each attribute defined in WF_ITEM_ATTRIBUTES describes one property of such an item type, governing how the workflow engine persists, validates, and displays that property.

From a dimensional modeling perspective, the ETRM relationship data classifies this object as hub-leaning. The table functions as a durable, business-key-driven hub of attribute identity (ITEM_TYPE plus NAME), while the descriptive metadata and localized content reside in related satellite-style tables such as WF_ITEM_ATTRIBUTES_TL and WF_ITEM_ATTRIBUTE_VALUES. This classification should be treated as a modeling suggestion rather than a mandated design.

Key Information Stored

The table is keyed by composite columns that form the business identity of each attribute definition. The documented unique index WF_ITEM_ATTRIBUTES_PK covers ITEM_TYPE, NAME, and ZD_EDITION_NAME, establishing the business-key candidate set. The primary key constraint WF_ITEM_ATTRIBUTES_PK is documented on ITEM_TYPE and NAME. The most significant columns are:

  • ITEM_TYPE — Identifies the workflow item type to which the attribute belongs; foreign key to WF_ITEM_TYPES.
  • NAME — The internal name of the attribute, unique within the item type.
  • SEQUENCE — Ordering position used when attributes are displayed or processed.
  • TYPE — The data type of the attribute (for example text, number, or date), which determines validation and storage behavior.
  • PROTECT_LEVEL — The protection level that controls who may modify the attribute definition.
  • CUSTOM_LEVEL — Indicates the customization level permitted against the attribute.
  • SUBTYPE — Optional subtype classification for the attribute.
  • FORMAT — Display or formatting mask applied to the attribute value.
  • TEXT_DEFAULT, NUMBER_DEFAULT, DATE_DEFAULT — Type-specific default values applied when no value is supplied.
  • SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, supporting multi-org or security-group partitioning.
  • ZD_EDITION_NAME — Editioning column supporting online patching in 12.2.x.

The table contains 13 documented columns in the 12.2.2 physical schema.

Common Use Cases and Queries

Typical usage centers on inspecting and reporting the attribute definitions that drive workflow behavior. Common scenarios include auditing default values, listing all attributes for a given item type, and confirming data types before writing workflow logic or notifications.

  • Listing attributes for a specific item type: SELECT name, type, sequence, text_default, number_default FROM wf_item_attributes WHERE item_type = :item_type ORDER BY sequence;
  • Identifying required customizations by protection level: SELECT item_type, name, protect_level, custom_level FROM wf_item_attributes WHERE custom_level = 'Y';
  • Reporting defaulted text attributes across item types for documentation purposes.
  • Joining to WF_ITEM_TYPES to confirm that an item type is active and persistent before consuming its attributes.
  • Cross-referencing WF_ITEM_ATTRIBUTE_VALUES to compare defined defaults against actual runtime values.

Related Objects

The table participates in a small but well-defined network of workflow metadata objects. The most significant related objects and their join columns are:

  • WF_ITEM_TYPES — referenced via WF_ITEM_ATTRIBUTES.ITEM_TYPE; the parent item type definition.
  • FND_SECURITY_GROUPS — referenced via WF_ITEM_ATTRIBUTES.SECURITY_GROUP_ID.
  • WF_ITEM_ATTRIBUTES_TL — the translated (language) attribute descriptions; joins on ITEM_TYPE and NAME.
  • WF_ITEM_ATTRIBUTE_VALUES — stores runtime attribute values; joins on ITEM_TYPE and NAME.

Together these objects form the metadata backbone of Oracle Workflow item type definitions in EBS Release 12.1.1 and 12.2.2.