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;
Comments |0|
Category: EBS