Workflow Scripts

1.Check for workflow components:
================================

set pagesize 400
set linesize 120
set pagesize 50
column COMPONENT_NAME format a45
column STARTUP_MODE format a15
column COMPONENT_STATUS format a15
select fsc.COMPONENT_NAME,fsc.STARTUP_MODE,fsc.COMPONENT_STATUS
from APPS.FND_CONCURRENT_QUEUES_VL fcq, fnd_svc_components fsc
where fsc.concurrent_queue_id = fcq.concurrent_queue_id(+)
order by COMPONENT_STATUS , STARTUP_MODE , COMPONENT_NAME;

-----------------------------------------------------------------------------

2.Workflow mails - Outbound 
===========================

This is when the outbound mails are not processed and OPEN - MAIL count keeps increasing. 

select status,mail_status,count(*) from wf_notifications where status='OPEN' group by status,mail_status;

-------------------------------------------------------------------------------

3.check for particular NID processing:
======================================

SELECT status, mail_status  FROM wf_notifications WHERE notification_id ='&nid';

-------------------------------------------------------------------------------

4.Check if any of the latest notification id's are sent or not:
==============================================================

select notification_id,to_char(begin_date,'HH24:MI:ss') from apps.wf_notifications where status='OPEN'
and mail_status='MAIL' order by notification_id;

---------------------------------------------------------------------------------