Search Results wf_item_types

Overview

The WF_ITEM_TYPES table is a core metadata repository within the Oracle E-Business Suite Workflow engine. Owned by the APPLSYS schema and part of the Application Object Library (FND) product, it serves as the master definition table for all workflow item types. An item type is a container that groups a set of workflow processes, activities, attributes, and other components into a logical unit. Every workflow process executed in Oracle EBS, from requisition approvals to sales order holds, is associated with a specific item type defined in this table. It is a foundational object for the Oracle Workflow technology stack, enabling the modular design, reuse, and management of business process definitions.

Key Information Stored

The primary column in the WF_ITEM_TYPES table is the NAME column, which serves as the unique identifier (primary key WF_ITEM_TYPES_PK) for a workflow item type. While the provided ETRM excerpt does not list all columns, based on its role as a definition table, it typically stores metadata such as the item type's display name, persistence type (e.g., temporary or permanent), protection level, and customization level. The NAME value is the critical reference point used throughout the Workflow engine and by other EBS modules to link their specific business entities to a corresponding workflow process definition.

Common Use Cases and Queries

This table is central to administrative, diagnostic, and integration tasks involving workflows. Common use cases include identifying all custom item types deployed in an instance, troubleshooting missing workflow definitions, or auditing workflow usage across modules. A fundamental query retrieves all defined item types, often joined with process activity tables to analyze a specific workflow's structure. For instance, to list all item types and a count of their associated processes, one might use a query such as: SELECT wit.name, COUNT(wa.instance_id) FROM wf_item_types wit LEFT JOIN wf_activities wa ON wit.name = wa.item_type AND wa.type='PROCESS' GROUP BY wit.name;. Technical consultants frequently reference this table when customizing standard workflows or developing new ones to ensure the correct item type is being utilized.

Related Objects

As indicated by the extensive foreign key relationships, WF_ITEM_TYPES is a parent table to numerous core Workflow engine tables and several application-specific setup tables. Key child objects within the Workflow engine include WF_ACTIVITIES (process and activity definitions), WF_ITEMS (runtime process instances), WF_ITEM_ATTRIBUTES, WF_MESSAGES, and WF_LOOKUP_TYPES_TL. Furthermore, its integration with EBS application modules is evidenced by foreign keys from tables such as OE_HOLD_DEFINITIONS (Order Management), JTF_UM_APPROVALS_B (User Management), and several OKE (Contract Management) tables. This demonstrates that the item type acts as the crucial link between a module's functional setup and the generic Workflow engine that executes the defined business logic.