Query to get Concurrent Program Details in Oracle EBS

SELECT fcp.concurrent_program_name,
  fcr.request_id,
  fcr.phase_code,
  fcr.status_code,
  fcr.logfile_name,
  fcr.outfile_name ,
  fcr.argument1 --parameters
 FROM fnd_concurrent_requests fcr ,
  fnd_concurrent_programs fcp
WHERE 1                       =1
AND fcp.concurrent_program_id = fcr.concurrent_program_id
ORDER BY 1 DESC; 

Leave a Reply

Your email address will not be published.