Sunday, January 17, 2016

Current workflow mailer log file location


Location -
-------------------------------------------------------------------------------------
select fl.meaning, fcp.process_status_code,decode ( fcq.concurrent_queue_name, 'WFMLRSVC', 'mailer container', 'WFALSNRSVC', 'listener container', fcq.concurrent_queue_name ), fcp.concurrent_process_id,os_process_id, fcp.logfile_namefrom fnd_concurrent_queues fcq, fnd_concurrent_processes fcp , fnd_lookups flwhere 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_codeand concurrent_queue_name in ('WFMLRSVC','WFALSNRSVC') order by fcp.logfile_name;

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

No comments:

Post a Comment

Oracle Database Administrator