WF Activity Status Summary

Description
Categories: Enginatics, Kcapps, Toolkit - Setup & Support
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,
wias.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
wias.activity_status=:activity_status
LOV
Show all active or errored
wias.activity_status in ('ACTIVE','NOTIFIED','ERROR','WAITING','DEFERRED','SUSPEND')
LOV