WF Activity Status Summary
Description
Categories: Enginatics, Kcapps
Repository: Github
Repository: Github
Summary counts of stuck and errored workflow activities to monitor required housekeeping activities
Run
WF Activity Status Summary and other Oracle EBS reports with Blitz Report™ on our demo environment
select count (*) count, wias.item_type, witv.display_name type_display_name, wpa.instance_label, wias.activity_result_code, xxen_util.meaning(wias.activity_status,'FND_WF_ACTIVITY_STATUS_LIST',0) activity_status from wf_item_activity_statuses wias, wf_process_activities wpa, wf_item_types_vl witv where 1=1 and wias.process_activity=wpa.instance_id and wias.item_type=witv.name(+) group by wias.item_type, witv.display_name, wpa.instance_label, wias.activity_result_code, wias.activity_status order by count (*) desc |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Activity Status |
|
LOV | |
Show all active or errored |
|
LOV |