LOCK in FND_CONCURRENT_PROCESSES

Hi,

From last month, we are detecting lock continous on FND_CONCURRENT_PROCESSES. When it occur, all concurrent request are locked and any request is executed.

So, the active session (sid 207) which is locking is always executing the following query:

SELECT Oracle_Process_Id,

Queue_Application_Id,

Concurrent_Queue_Id,

Os_Process_Id,

Lk_Handle,

Node_Name,

Db_Instance

FROM Fnd_Concurrent_Processes

WHERE Concurrent_Process_ID = :cpid

AND Process_Status_Code IN ('A', 'T', 'C', 'P')

ORDER BY Node_Name, Db_Instance

FOR UPDATE OF Concurrent_Process_Id

One sid (286) which is locked (althouth appear like session which lock) is executing