Search Results wf_item_attributes

Overview

The WF_ITEM_ATTRIBUTES table is a core repository within the Oracle E-Business Suite (EBS) Workflow engine, residing in the APPLSYS schema under the Application Object Library (FND) product. It serves as the master definition table for all attributes associated with workflow items. In Oracle Workflow, an item type is a container for a business process, and each process is defined by a set of attributes that store runtime data, control flow, and provide contextual information. This table defines the metadata for those attributes—their names, data types, formats, and default behaviors—for every item type in the system. It is fundamental to the engine's ability to store, validate, and manipulate data as a workflow process executes.

Key Information Stored

The table's structure is defined by a composite primary key on ITEM_TYPE and NAME, ensuring unique attribute definitions per item type. Key columns include ITEM_TYPE, linking the attribute to its parent workflow definition in WF_ITEM_TYPES, and NAME, the unique identifier for the attribute within that item type. Other critical columns define the attribute's characteristics: TYPE (the datatype, such as TEXT, NUMBER, or DATE), FORMAT (a mask for display and validation), PROTECT_LEVEL and CUSTOM_LEVEL for personalization security, and SUBTYPE for specialized attribute behaviors. The TEXT_DEFAULT and NUMBER_DEFAULT columns provide initial values. Collectively, these columns create a blueprint for the data elements that will populate the runtime attribute values table.

Common Use Cases and Queries

This table is central to workflow administration, debugging, and integration. Common use cases include auditing the complete attribute definition for a specific item type, identifying attributes of a particular data type for data migration scripts, and troubleshooting missing or misconfigured attributes. A typical administrative query retrieves all attributes for a given process:

• SELECT name, type, format, text_default FROM apps.wf_item_attributes WHERE item_type = '&ITEM_TYPE' ORDER BY name;

Another frequent pattern involves joining with WF_ITEM_ATTRIBUTE_VALUES to analyze definitions alongside runtime data for active processes. Developers also query this table when extending standard workflows to understand the existing attribute landscape before adding custom attributes via the appropriate Oracle Workflow APIs.

Related Objects

WF_ITEM_ATTRIBUTES is a pivotal hub within the Workflow data model. Its primary relationship is with WF_ITEM_TYPES via a foreign key on ITEM_TYPE. The WF_ITEM_ATTRIBUTE_VALUES table holds the runtime instance data for each attribute defined here, linked by ITEM_TYPE and NAME. The WF_ITEM_ATTRIBUTES_TL table provides translated names and descriptions for the attributes, supporting multilingual implementations. Crucially, direct manipulation of this table is strongly discouraged; instead, definitions should be created or modified using the official Workflow APIs, such as those in the WF_ENGINE or WF_DIRECTORY packages, which maintain integrity and propagate changes correctly.