WF Activity Status Summary
Description
- Categories
- Enginatics
- Repository
- GitHub
Summary counts of stuck and errored workflow activities to monitor required housekeeping activities
SQL 22 lines
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 |
Parameters 2
| Parameter | Type | List of values SQL | |
|---|---|---|---|
| Activity Status | LOV |
| |
| Show all active or errored | LOV |
|