--Find Run request time, parameters, etc. (can be a user's, a report)
Select C.user_name,
Papf.full_name,
B.user_concurrent_program_name,
A.request_date,
A.argument_text,
(a.actual_completion_date-a.actual_start_date) * minutes,
A.actual_start_date,
A.actual_completion_date,
A.REQUEST_ID,
A.outfile_name
From Fnd_concurrent_requests A,
FND_CONCURRENT_PROGRAMS_VL B,
Fnd_user C,
Per_all_people_f PAPF
where a.concurrent_program_id = b.concurrent_program_id
and a.requested_by = c.user_id
and C.user_name = Papf.employee_number (+)
And a.actual_completion_date is not NULL
and b.user_concurrent_program_name = ' Your program name '---like '%xxx% '
and C.user_name = ' The user you are looking for '
and A.request_date <=
To_date (' 2005-03-01 23:59:59 ', ' yyyy-mm-dd hh24:mi:ss ')
and A.request_date >=
To_date (' 2005-03-01 00:00:00 ', ' yyyy-mm-dd hh24:mi:ss ')
and a.request_id > 2254198---In order to improve speed, choose a suitable time-point ID
EBS Lookup Run request time, parameters, etc.