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 WF Notifications ONT Transaction Types and Line WF Processes ONT Workflow Assignments PER Approvals Deviation PO IDV Data template PO Award Data template FLS PA Budgets and Actuals - Totals, FLS PA Project, PA Fundings, PA Projects GW-Material Account Distributions
Blitz Report™

Blitz Report™ provides multiple benefits: