Workflow scripts for Different Errors

Below are the helpful queries beginners can use to find out errors in oracle workflows:-

1) SELECT 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 3 DESC, 1 DESC, 2;


2) SELECT item_type
,parent_item_type
,DECODE (end_date, NULL, 'OPEN', 'CLOSED')
error_type_status
,COUNT (*)
FROM wf_items
WHERE parent_item_type is not null
AND item_type in ('CUNNLWF','DOSFLOW','DOSFLOWE',
'ECXERROR','HRSSA','HRSTAND','HXCEMP','IBUHPSUB','OKLAMERR',
'OMERROR','PARMAAP','PARMATRX','POERROR','WFSTD','XDPWFSTD',
'ZPBWFERR', 'WFERROR')
GROUP BY item_type
,parent_item_type
,DECODE (end_date, NULL, 'OPEN', 'CLOSED')
ORDER BY item_type,parent_item_type;

3) SELECT COUNT (*)

,v.text_value

,min(i.begin_date)

,max(i.begin_date)

FROM wf_item_attribute_values v

,wf_items i

WHERE v.item_key=i.item_key

AND v.item_type = i.item_type

AND v.item_type = 'WFERROR'

AND v.NAME = 'EVENT_NAME'

AND v.text_value IS NOT NULL

GROUP BY text_value

ORDER BY text_value;