Concurrent Request無法取消執行

當Cancel Request時,出現下列的錯誤訊息:
Request xxxxxx can no longer be cancelled. The Concurrent Manager Process that was running this request has exited abnormally. The ICM will mark this request as completed with error.


在網路上找到解決的方式如下:
Manually cancel the request out of the queue with the following SQL against the offending
request id(s). This can be safely done while managers are up and running

UPDATE fnd_concurrent_requests
        SET phase_code = 'C', status_code = 'X'
         WHERE request_id = 10975869;

回到EBS,可以發現它已經Cancel了

Oracle DB的listener.log清理