Easily identify executable file name of concurrent request. SELECT fcpv.user_concurrent_program_name concurrent_program_name, fe.execution_file_name source_name, fl.meaning program_type FROM apps.fnd_concurrent_programs_vl fcpv, apps.fnd_executables fe, apps.fnd_lookups fl WHERE fe.executable_id = fcpv.executable_id AND fl.lookup_type = 'CP_EXECUTION_METHOD_CODE'...

Get log file & output file location of concurrent request with all the details. SELECT DISTINCT fcp.user_concurrent_program_name, fcp.concurrent_program_name, fcr.request_id, fcr.request_date, flv.meaning status, fcr.status_code, fcr.completion_text, fcr.logfile_name, fcr.outfile_name, fcr.argument_text FROM apps.fnd_concurrent_programs_vl fcp,...

Find out the status of concurrent request which is pending in oracle EBS. select fcr.REQUEST_ID, fu.user_name, fcr.PHASE_CODE, fcr.STATUS_CODE, (fcr.ACTUAL_COMPLETION_DATE - fcr.ACTUAL_START_DATE) * 24 * 60 TIME_MINS, fcpt.USER_CONCURRENT_PROGRAM_NAME, fcp.CONCURRENT_PROGRAM_NAME, fcr.ACTUAL_START_DATE, fcr.ACTUAL_COMPLETION_DATE,...

Query provide output of the concurrent request which is executed between date & time range in database / oracle EBS. A) If need any specific concurrent request which is executed...

Output of the query display all the concurrent request which is running presently in database / oracle EBS. SELECT distinct a.request_id ,frt.responsibility_name ,ctl.user_concurrent_program_name ,a.phase_code,actual_start_date ,fu.user_name ,Round(((sysdate - a.actual_start_date) / (1...