WF Activity Status Summary

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Summary counts of stuck and errored workflow activities to monitor required housekeeping activities

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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 WF Notifications ONT Transaction Types and Line WF Processes ONT Workflow Assignments PER Approvals Deviation PO IDV Data template PO Award Data template GW-Material Account Distributions PO IDV Mod datatemplate for FPDS-NG
Blitz Report™

Blitz Report™ provides multiple benefits: