Search Results wf_item_activity_statuses

Overview

The WF_ITEM_ACTIVITY_STATUSES table is a core runtime table within the Oracle E-Business Suite (EBS) Workflow engine, owned by the APPLSYS schema. As a component of the Application Object Library (FND), its primary role is to persist the execution state of individual activities (steps) for a specific work item instance. Each row in this table represents the status of a single activity within a running workflow process, enabling the engine to track progress, manage transitions, and determine the next steps for an item. It is a critical data store for the operational integrity and state management of the Oracle Workflow runtime environment in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is designed to uniquely identify a workflow item and its constituent activities. Its primary key consists of ITEM_TYPE, ITEM_KEY, and PROCESS_ACTIVITY, which together pinpoint a specific activity instance. The ITEM_TYPE and ITEM_KEY columns link to the parent work item in the WF_ITEMS table. The PROCESS_ACTIVITY column is a foreign key to the WF_PROCESS_ACTIVITIES table, identifying the definition of the activity being executed. A critical optional column is NOTIFICATION_ID, which serves as a foreign key to the WF_NOTIFICATIONS table. This link is populated when the activity is a notification, connecting the activity's status to the specific notification sent to a user or role. The table also stores the activity's current status (e.g., ACTIVE, COMPLETE, ERROR), result, start date, and end date, providing a complete historical and current audit trail.

Common Use Cases and Queries

This table is essential for monitoring, troubleshooting, and reporting on workflow processes. Common use cases include diagnosing stalled workflows by identifying activities stuck in an 'ACTIVE' state, analyzing process performance by calculating activity duration, and auditing the complete execution path of a specific item. A typical diagnostic query to find active activities for a specific item is:

• SELECT process_activity, activity_status, begin_date FROM apps.wf_item_activity_statuses WHERE item_type = '<TYPE>' AND item_key = '<KEY>' AND activity_status = 'ACTIVE';

For performance reporting, analysts often join this table with WF_ITEMS and WF_PROCESS_ACTIVITIES to correlate runtime status with process definitions and item attributes, generating metrics on cycle time and step completion rates.

Related Objects

WF_ITEM_ACTIVITY_STATUSES has integral relationships with other core Workflow tables, as defined by its foreign keys. The WF_ITEMS table is the parent, providing the master definition of the work item. The WF_PROCESS_ACTIVITIES table supplies the metadata for the activity being performed. The WF_NOTIFICATIONS table is linked when the activity is a notification type. Key related APIs include the WF_ENGINE package, which reads from and writes to this table during process execution, and the Workflow Monitor, which queries this table to display the runtime status diagram. Direct data manipulation via SQL is generally discouraged; interaction should occur through the supported Workflow engine APIs.