Workflow mailer log file location for Oracle EBS R12.2

Log Location of WF mailer: 

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

--------------------------------------------------------------------------------
/appsolworld/a1/inst/apps/TANSID_shsdb01/logs/appl/conc/log/FNDCP*.txt


Comments

Popular posts from this blog

How to drop index and before dropping it how to get the DDL.

How to set up the Oracle Wallets in Oracle Database 19C

PRVG-11250 : The check "RPM Package Manager database" was not performed because

ORA-00257:archiver error, connect internal only until freed

Linux OL7/RHEL7: PRVE-0421 : No entry exists in /etc/fstab for mounting /dev/shm

Verifying Daemon “Avahi-Daemon” Not Configured And Running …FAILED (PRVG-1360)

SKIP DNS RESLOV.CONF CHECK DURING RAC CONFIGURATION

How to write to a CSV file using Oracle SQL*Plus

Change Password in an Oracle Database