Hi,

TO Cancel user requests ————————

• Check for the user Id for the requests to be canceled.

SELECT DISTINCT fu.user_id, fu.user_name, fu.employee_id, fu.start_date, fu.end_date, fu.creation_date, fu1.user_name AS "User Created By" FROM fnd_user fu, fnd_user fu1 WHERE fu.end_date IS NULL AND fu.created_by = fu1.user_id(+) AND fu.created_by NOT IN (0, 1) ORDER BY 1;

• Check for the running request for that user to be canceled.

SELECT * FROM fnd_concurrent_requests WHERE phase_code IN ('R') AND requested_by = 2111 ORDER BY last_update_date DESC

• Cancel the request of that particular user from the back end.

UPDATE fnd_concurrent_requests SET phase_code = 'C', status_code = 'D' WHERE phase_code = 'R' AND requested_by = 2933; 

COMMIT; 

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

Regards

Mahmoud Morsy.