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 between time range then remove the comment from 'pt.user_concurrent_program_name' and define the concurrent program name.
B) If need output of query which request is executed by user between time range then remove comment from the 'fu.user_name'.
SELECT pt.user_concurrent_program_name Concurrent_Program
, f.actual_start_date
, f.actual_completion_date
, fu.user_name
, TRUNC(((f.actual_completion_date-f.actual_start_date)/(1/24))*60) runtime
, f.request_id
, f.argument_text
FROM fnd_concurrent_programs p
, fnd_concurrent_programs_tl pt
, fnd_concurrent_requests f
,apps.fnd_user fu
WHERE f.concurrent_program_id = p.concurrent_program_id
and f.program_application_id = p.application_id
and f.concurrent_program_id = pt.concurrent_program_id
and f.program_application_id = pt.application_id
AND f.requested_by = fu.user_id
AND pt.language = USERENV('Lang')
--AND pt.user_concurrent_program_name='Create Accounting' --Specific concurrent program need if required
--AND fu.user_name = 'SYSADMIN' --Specify Username
and to_char(f.actual_start_date, 'MM/DD/YYYY HH24:MI:SS') >='06/01/2019 10:00:00'
and to_char(f.actual_start_date, 'MM/DD/YYYY HH24:MI:SS') <='06/30/2020 10:15:00'
ORDER by f.actual_completion_date - f.actual_start_date desc;How many concurrent request executed / run between the date & time range will be getting by below query.
SELECT count(*)
FROM fnd_concurrent_programs p
, fnd_concurrent_programs_tl pt
, fnd_concurrent_requests f
,apps.fnd_user fu
WHERE f.concurrent_program_id = p.concurrent_program_id
and f.program_application_id = p.application_id
and f.concurrent_program_id = pt.concurrent_program_id
and f.program_application_id = pt.application_id
AND f.requested_by = fu.user_id
AND pt.language = USERENV('Lang')
and to_char(f.actual_start_date, 'MM/DD/YYYY HH24:MI:SS') >='11/26/2015 14:30:00'
and to_char(f.actual_start_date, 'MM/DD/YYYY HH24:MI:SS') <='11/26/2015 15:30:00'
ORDER by f.actual_completion_date - f.actual_start_date desc;