Thursday, February 15, 2018


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;



No comments:

Post a Comment