Workflow Scripts

1.To find our workflow log files

SELECT fcp.logfile_name FROM fnd_concurrent_queues fcq, fnd_concurrent_processes fcp, fnd_lookups flkup WHERE concurrent_queue_name in ('WFMLRSVC')
AND fcq.concurrent_queue_id = fcp.concurrent_queue_id AND fcq.application_id = fcp.queue_application_id AND flkup.lookup_code=fcp.process_status_code
AND lookup_type ='CP_PROCESS_STATUS_CODE' AND meaning='Active';

2.Workflow Mailer Outbound

SELECT b.component_name,
c.parameter_name,
a.parameter_value
FROM fnd_svc_comp_param_vals a,
fnd_svc_components b,
fnd_svc_comp_params_b c
WHERE b.component_id = a.component_id
AND b.component_type = c.component_type
AND c.parameter_id = a.parameter_id
AND c.encrypted_flag = 'N'
AND b.component_name like '%Mailer%'
AND c.parameter_name in ('OUTBOUND_SERVER', 'REPLYTO')
ORDER BY c.parameter_name;

3.Workflow Sendmail Check

echo "test" |mailx -s "test" myoracletechmailbox@gmail.com

4.How to determine WF Java Mailer availability without using OAM

SELECT Component_name, Component_Status
FROM FND_SVC_COMPONENTS
WHERE component_type = 'WF_MAILER';

Reference: Metalink Doc: 316352.1 Note: 415516.1 - How to Check Whether Notification Mailer is Working or Not).

column component_name format a40
column component_status format a8
column startup_mode format a8
column inbound_agent_name format a15
column outbound_agent_name format a15

select component_id, component_name,component_status,component_type,
startup_mode,inbound_agent_name,outbound_agent_name
--creation_date
from fnd_svc_components c
order by component_id;

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;
-----------------------------------------------------------------------------
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(+)
and fcq.USER_CONCURRENT_QUEUE_NAME like '%Mail%';

set linesize 120
set pagesize 50
column COMPONENT_NAME format a50
column STARTUP_MODE format a15
column COMPONENT_STATUS format a20
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;