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,...