Thursday, June 13, 2019

Cancel Scheduled Concurrent requests

--How to Cancel a Concurrent Request Stuck in the Queue? [ID 749748.1]
--CCM.sql Diagnostic Script for Concurrent Manager [ID 171855.1]
--CMCLEAN.SQL - Non Destructive Script to Clean Concurrent Manager Tables [ID 134007.1]
--How to Clear a Request Set Stuck in RUNNING / PAUSED Status [ID 1081912.6]

--STATUS_CODE Column:
--A Waiting  B Resuming C Normal D Cancelled E Error F Scheduled G Warning H On Hold I Normal M No Manager
--Q Standby R Normal S Suspended T Terminating U Disabled W Paused X Terminated Z Waiting

--PHASE_CODE column
--C Completed I Inactive P Pending R Running

update FND_CONCURRENT_REQUESTS set phase_code='C',status_code='D' where phase_code='R' and requested_by in ('1187','1158','2842','3481')

commit

select * from FND_CONCURRENT_REQUESTS where phase_code='R' and requested_by in ('1757','1197','1186','1185')

--Update a specifix concurrent program
update FND_CONCURRENT_REQUESTS set phase_code='C',status_code='D' where phase_code='R' --and requested_by in ('1757','1197','1186','1185')
and REQUEST_ID in ('12095604','12095598','12095589')

commit

select * from FND_CONCURRENT_REQUESTS where phase_code='R' --and requested_by in ('1757','1197','1186','1185')
and REQUEST_ID in ('11150939','11134004','11130061')


-- To get the list of Scheduled Concurrent Requests ------------------------------------------------------------

SELECT
a.request_id,
A.REQUESTED_BY,
a.program,
a.argument_text,
a.requested_start_date,
b.resubmit_interval,
b.resubmit_interval_unit_code,
a.requestor
FROM  apps.fnd_conc_req_summary_v a,    apps.fnd_concurrent_requests b
WHERE a.phase_code='P' AND a.request_id=b.request_id
--and a.REQUESTOR not in ('SYSADMIN')
ORDER BY a.request_id DESC

No comments:

Post a Comment

Some Tips About FNDLOAD

Data Synchronization  Data Synchronization is a process in which some setup data would be synchronized, and this would be more important w...