Hi ,

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

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

[code]
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;
[/code]

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

[code]
SELECT *
FROM fnd_concurrent_requests
WHERE phase_code IN (‘R’) AND requested_by = 2111
ORDER BY last_update_date DESC
[/code]

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

[code]

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

COMMIT;

[/code]

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.