Workflow mailer log file location Oracle EBS R12

Workflow log location
++++++++++++++

cd $APPLCSF/$APPLLOG

ls -ltr FNDCPGSC*.txt

OR

Below query shows active workflow log file.

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’;

--------------------------------------------------------------------------------
/u01/app/****/****/inst/apps/PSSPI_servername/logs/appl/conc/log/FNDCPGSC200
49.txt

Thanks
Sreeharsha