當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了