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;

7 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
  5. Thanks for the sql.... it really helped me

    ReplyDelete

Number of Visitors