Oracle EBS: Request XXXXXXX can no longer be cancelled

由於報表執行過久, 把Child request cancel後, 認為parent應也會終止, 但過了數小時仍在Running/Paused, 按下Cancel時, 出現以下訊息:

Request XXXXXXX 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.

再等了等, 還是一樣. 上網找了資訊, 建議可用note 134035.1的SQL檢視request:

Concurrent Processing - ANALYZEREQ.SQL Detailed Analysis of One Concurrent Request (Release 11 and up) (Doc ID 134035.1)

要更改request的狀態, 可用以下SQL:

    UPDATE fnd_concurrent_requests

       SET phase_code = 'C', status_code = 'X'

     WHERE request_id = ...

目前看來OK, 沒什麼問題.