WF Activity Status Summary

Description

Categories
Enginatics
Repository
GitHub
Summary counts of stuck and errored workflow activities to monitor required housekeeping activities

SQL 22 lines

Parameters 2

ParameterTypeList of values SQL
Activity StatusLOV
wias.activity_status=xxen_util.lookup_code(:activity_status,'FND_WF_ACTIVITY_STATUS_LIST',0)
Show all active or erroredLOV
wias.activity_status in ('ACTIVE','NOTIFIED','ERROR','WAITING','DEFERRED','SUSPEND')