CANCEL REQUEST from BACKEND

CANCEL REQUEST from BACKEND

SQL> update fnd_concurrent_requests set status_code='D', phase_code='C' where request_id='REQUEST_ID';
SQL> update fnd_concurrent_requests set status_code='D', phase_code='C' where request_id=&req_id;

CANCEL ALL REQEUST OF ONE USER

SQL> select * from fnd_user where user_name like 'user_name';

SQL> update fnd_concurrent_requests set status_code='D', phase_code='C' where requested_by=:p_user_id;


===============================