Is there a way to cancel a concurrent request from the command line?
Hello CCP experts,
I am using CONCSUB to submit concurrent requests from the command line and would like the ability to cancel requests from the command line as well.
WHERE request_id = '<request id>';
commit;
After researching, it appears there are only two ways to cancel concurrent requests.
1. Run an SQL script.
SQL> UPDATE fnd_concurrent_requests
SET phase_code = 'C', status_code = 'X' WHERE request_id = '<request id>';
commit;
2. Issue CONCSUB <Username/Password> SYSADMIN 'System Administrator' SYSADMIN CONCURRENT FND ABORT
which will shutdown the managers and all requests that have not completed.
I would prefer something like:
CONCSUB <Username/Password> SYSADMIN 'System Administrator' SYSADMIN CONCURRENT FND ABORT <request id>
0