Tuesday, October 22, 2019

Workflow Mailer log location

Below query can be used to find the workflow mailer log location and the file name.

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


****************************நன்றி****************************

-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

IAS Cache initialization failed

 Today I faced an Issue in R12.2 instance. The solution I followed to overcome the issue is very simple, but they are more than one solution...

  • Common R12.2 adcfgclone Issues
    ERROR: Failed to configure the target system – Failed to enable EBS_LOGON trigger The clone procedure for EBS R12.2 is quite different...
  • ERROR: txkWfClone.sh exited with status 1
    I faced this error while cloning R12.2.5 in my environment. Below are the step by step process, I followed to overcome this issue. ...
  • Workflow Mailer log location
    Below query can be used to find the workflow mailer log location and the file name. SELECT fcp.logfile_name FROM fnd_concurrent_queues fc...