DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Monday, September 14, 2015

TO CHECK THE CURRENT WORKFLOW MAILER CONFIGURATION AND LOGFILES


SQL>

col MEANING for a10;
col DECODE(FCQ.CONCURRENT_QUEUE_NAME) for a30;
col OS_PROCESS_ID for a10;
col LOGFILE_NAME for a50;
select fl.meaning,fcp.process_status_code, 
decode(fcq.concurrent_queue_name,'WFMLRSVC','maile r container','WFALSNRSVC','listener container',fcq.concurrent_queue_name),
fcp.concurrent_process_id,os_process_id, fcp.logfile_name
from fnd_concurrent_queues fcq, fnd_concurrent_processes fcp , fnd_lookups fl
where fcq.concurrent_queue_id=fcp.concurrent_queue_id and fcp.process_status_code='A'
and fl.lookup_type='CP_PROCESS_STATUS_CODE' and
fl.lookup_code=fcp.process_status_code
and concurrent_queue_name in('WFMLRSVC','WFALSNRSVC')
order by fcp.logfile_name;


Output :
======

EANING    P DECODE(FCQ.CONCURRENT_QUEUE_NA CONCURRENT_PROCESS_ID OS_PROCESS LOGFILE_NAME
---------- - ------------------------------ --------------------- ---------- --------------------------------------------------
Active     A maile r container                             692801 60228270   /test01/oracle/TEST/inst/apps/TEST_host/logs/appl/conc/log/FNDCPGSC692801.txt

Active     A listener container                            692802 63701744   /test01/oracle/TEST/inst/apps/TEST_host/logs/appl/conc/log/FNDCPGSC692802.txt

No comments: