Query to get Errored Workflows in Oracle Apps

Workflows can error for a variety of reasons. Regardless of the reason, these errors must be corrected
and the workflow either continued or aborted. From Workflow Administrator Responsibility  we can identify all errored workflows and the activity that errored.

The following query will show if there are any errored workflows:

  SELECT COUNT (*) WF_Error_Count,
                  item_type,
                  activity_name,
                 MIN (item_begin_date),
                 MAX (item_begin_date)
    FROM wf_item_activity_statuses_v
   WHERE activity_status_code = 'ERROR'
        AND item_end_date IS NULL
GROUP BY item_type, activity_name
ORDER BY item_type;