WF Activity Status Summary

➜ Back to Library
Description
Categories: Enginatics, Kcapps
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 
wias.activity_status=xxen_util.lookup_code(:activity_status,'FND_WF_ACTIVITY_STATUS_LIST',0)
 LOV
Show all active or errored 
wias.activity_status in ('ACTIVE','NOTIFIED','ERROR','WAITING','DEFERRED','SUSPEND')
 LOV
Download
 
Related Blitz Reports
OKL Termination Quotes ONT Transaction Types and Line WF Processes ONT Workflow Assignments WF Notifications PER Approvals Deviation PO IDV Data template PO Award Data template PO IDV Mod datatemplate for FPDS-NG AP Credit Card Historical Transactions Management- Not Supported: Reserved For Future Use
Blitz Report™

Blitz Report™ provides multiple benefits: