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 / 24)) * 60,2) runtime
,a.argument_text
FROM APPLSYS.fnd_Concurrent_requests a,APPLSYS.fnd_concurrent_processes b
,applsys.fnd_concurrent_queues q
,APPLSYS.fnd_concurrent_programs c
,APPLSYS.fnd_concurrent_programs_tl ctl
,apps.fnd_user fu
,apps.FND_RESPONSIBILITY_TL frt
WHERE a.controlling_manager = b.concurrent_process_id
AND a.concurrent_program_id = c.concurrent_program_id
AND a.program_application_id = c.application_id
AND a.phase_code = 'R'
AND a.status_code = 'R'
--AND ctl.user_concurrent_program_name='Create Accounting' --You can define any specific program name
AND b.queue_application_id = q.application_id
AND b.concurrent_queue_id = q.concurrent_queue_id
AND ctl.concurrent_program_id = c.concurrent_program_id
AND a.requested_by = fu.user_id
AND a.responsibility_id = frt.responsibility_id
ORDER BY a.actual_start_date; DBA can cancel concurrent program from backend
UPDATE fnd_concurrent_requests
SET phase_code = 'C', status_code = 'X'
WHERE request_id = '&request_id';During clone activity if DBA wanted to kill all the request from backend at a time then executed below script with date which is stopped all the concurrent request.
UPDATE fnd_concurrent_requests
SET phase_code = 'C', status_code = 'X'
WHERE request_id in (select b.request_id
from APPS.FND_CONCURRENT_PROGRAMS_VL a,
APPS.FND_CONCURRENT_REQUESTS b
where a.CONCURRENT_PROGRAM_ID = b.CONCURRENT_PROGRAM_ID
and a.APPLICATION_ID = b.PROGRAM_APPLICATION_ID
and b.PHASE_CODE = 'R'
and b.PHASE_CODE = 'P'
and to_char(b.requested_start_date, 'MM/DD/YYYY HH24:MI:SS') >='01/08/2019 08:00:00'
and to_char(b.requested_start_date, 'MM/DD/YYYY HH24:MI:SS') <='10/10/2019 20:00:00');