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.

Hello Mina,

you can use the below query.

[code]

SELECT DISTINCT
c.USER_CONCURRENT_PROGRAM_NAME,
ROUND ( ( (SYSDATE – a.actual_start_date) * 24 * 60 * 60 / 60), 2)
AS Process_time,
a.request_id,
a.parent_request_id,
a.request_date,
a.actual_start_date,
a.actual_completion_date,
(a.actual_completion_date – a.request_date) * 24 * 60 * 60
AS end_to_end,
(a.actual_start_date – a.request_date) * 24 * 60 * 60 AS lag_time,
d.user_name,
a.phase_code,
a.status_code,
a.argument_text,
a.priority
FROM apps.fnd_concurrent_requests a,
apps.fnd_concurrent_programs b,
apps.FND_CONCURRENT_PROGRAMS_TL c,
apps.fnd_user d
WHERE a.concurrent_program_id = b.concurrent_program_id
AND b.concurrent_program_id = c.concurrent_program_id
AND a.requested_by = d.user_id
AND status_code = ‘C’
AND c.USER_CONCURRENT_PROGRAM_NAME =
‘*************Name Of Report**********’
ORDER BY Process_time DESC;
[/code]

Thanks ,

Mahmoud Morsy