Monday, 20 August 2012

Current workflow mailer log file location

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;

6 comments:

  1. Nice one buddy :)

    ReplyDelete
  2. This comment has been removed by the author.

    ReplyDelete
  3. Useful one. Thanks buddy !

    ReplyDelete
  4. i have a requirement to attach the approved mail notification to PO Header, Can you please help me on this.
    1st thing what is the location for notification file.

    ReplyDelete

Number of Visitors