Concurrent Manager log location

select fcp.node_name,
TO_CHAR(fcp.last_update_date, 'DD-MON-RR HH24:MI:SS'),
fcp.logfile_name
FROM fnd_concurrent_processes fcp, fnd_concurrent_queues fcq
WHERE fcp.concurrent_queue_id = fcq.concurrent_queue_id
AND fcp.queue_application_id = fcq.application_id
AND fcq.concurrent_queue_name = 'FNDCPOPP'
order by 2 desc; 

Concurrent Queue Status

SELECT a.concurrent_queue_name, SUBSTR(b.os_process_id,0,10) "OS Proc", b.oracle_process_id "Oracle ID",  b.process_status_code
FROM fnd_concurrent_queues a, fnd_concurrent_processes b
WHERE a.concurrent_queue_id=b.concurrent_queue_id
AND b.process_status_code='A'
ORDER BY b.process_status_code;

Manger of a request ID

select b.USER_CONCURRENT_QUEUE_NAME from fnd_concurrent_processes a,

fnd_concurrent_queues_vl b, fnd_concurrent_requests c

where a.CONCURRENT_QUEUE_ID = b.CONCURRENT_QUEUE_ID

and a.CONCURRENT_PROCESS_ID = c.controlling_manager

and c.request_id = XXXXX;

Request to check duplicate

SELECT fcr.request_id

       ,fcr.root_request_id "Schedule Request ID"

       ,fu.user_name "Submitted By"

       ,fct.user_concurrent_program_name

       ,fcr.argument_text

       ,fcr.RESUBMIT_INTERVAL

       ,fcr.RESUBMIT_INTERVAL_UNIT_CODE

FROM apps.fnd_concurrent_requests fcr

     ,apps.FND_concurrent_programs_tl fct

     ,apps.fnd_user fu

WHERE fcr.concurrent_program_id = fct.concurrent_program_id

and fcr.phase_code    <>'C'

and fcr.requested_by = fu.user_id

AND fcr.root_request_id IN

  (SELECT root_request_id

  FROM apps.fnd_concurrent_requests

  WHERE phase_code    <>'C'

  AND root_request_id IS NOT NULL

  GROUP BY root_request_id

  HAVING COUNT(*)> 1

  )

  order by fcr.root_request_id asc;

Query to find log file count

SELECT 

         fcr.logfile_node_name,count(1)

    FROM apps.fnd_concurrent_requests fcr,

         apps.fnd_concurrent_programs fcp,

         apps.fnd_concurrent_programs_tl fcpt,

         apps.fnd_user fu,

         apps.fnd_responsibility_tl fr

   WHERE 1 = 1

     AND fcr.actual_start_date >= to_date('2/16/2017 10:10','MM/DD/RRRR hh24:mi')

     AND fcr.concurrent_program_id = fcp.concurrent_program_id

     AND fcp.concurrent_program_id = fcpt.concurrent_program_id

     AND fcr.program_application_id = fcp.application_id

     AND fcp.application_id = fcpt.application_id

     AND fcr.requested_by = fu.user_id

     AND fcpt.LANGUAGE = 'US'

     AND fcr.responsibility_id = fr.responsibility_id

     AND fr.LANGUAGE = 'US'

group by fcr.logfile_node_name;

Finding the running node of a concurrent request

SELECT outfile_node_name,          

       a.actual_start_date,

      a.actual_completion_date ,

      a.*

   FROM fnd_concurrent_requests a

WHERE concurrent_program_id =

        (select concurrent_program_id from fnd_concurrent_programs_tl where       user_concurrent_program_name like 'Programme Name' )

 --and argument1 = 'CONCUR' and argument2 = 'GET'

order by REQUESTED_START_DATE desc;

 EBS monitoring script

• Run Away Process
• Frmweb process