Concurrent Request Count Day wise

set pause off
set pagesize 2000
set linesize 120
set wrap off
column user_concurrent_program_name format a45 noprint
column argument_text format a45 print
column user_name format a15
column start_time format a15
column end_time format a15
column comp_time format 9999.99
select request_id,
user_concurrent_program_name,
to_char(actual_start_date,'DD-MON HH24:MI:SS') START_TIME,
to_char(ACTUAL_COMPLETION_DATE,'DD-MON HH24:MI:SS') END_TIME,
(actual_completion_date-actual_start_date)*24*60 comp_time, argument_text,user_name, status_code, phase_code
from apps.fnd_concurrent_requests, apps.fnd_concurrent_programs_tl,apps.fnd_user
where fnd_concurrent_requests.concurrent_program_id = fnd_concurrent_programs_tl.concurrent_program_id
--and user_concurrent_program_name like '%Gather Schema%'
and fnd_concurrent_requests.concurrent_program_id=57389
and fnd_concurrent_programs_tl.language='US'
and requested_by=user_id and status_code in ('C')
order by actual_start_date;


Example:


COUNT(*) TRUNC(A.ACTUAL_COM
---------- ------------------
       205 01-NOV-16
       202 02-NOV-16
       220 03-NOV-16
       244 04-NOV-16
        38 05-NOV-16