Reports2017-11-18T12:27:27+00:00

WF Activity Status Summary

Description
Categories: Application, Enginatics
Summary counts of stuck and errored workflow activities to monitor required housekeeping activities

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
Show all active or errored
wias.activity_status in ('ACTIVE','NOTIFIED','ERROR','WAITING','DEFERRED','SUSPEND')
LOV
Activity Status
wias.activity_status=:activity_status
LOV

By continuing to use the site, you agree to the use of cookies. Accept