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;

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

1 comment:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete

Note: Only a member of this blog may post a comment.