Concurrent Processing - ORA-00060: Deadlock Detected - UPDATE FND_CONCURRENT_QUEUES (Doc ID 866298.1)

Last updated on AUGUST 25, 2016

Applies to:

Oracle Concurrent Processing - Version 11.5.10.2 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
Alert, log, concurrent, ORA-00060:, Deadlock Detected, UPDATE FND_CONCURRENT_QUEUES, FND_CONCURRENT_REQUESTS



Symptoms

The Alert log reports an ORA-00060: Deadlock on a daily basis on the FND_CONCURRENT_QUEUES table:

"Mon Jul 27 01:47:28 2009
ORA-00060: Deadlock detected. More info in file
/ora/TS11/dumpdest/diag/rdbms/ts11/TS11/trace/TS11_ora_14335.trc.
...
DEADLOCK DETECTED ( ORA-00060 )

[Transaction Deadlock]
...
----- Current SQL Statement for this session (sql_id=fxrsqg45jy3kt) -----
UPDATE FND_CONCURRENT_QUEUES SET RUNNING_PROCESSES = 1, MAX_PROCESSES = 1, CONTROL_CODE = NULL
WHERE MANAGER_TYPE = 6 AND NODE_NAME = :B1
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0xfb2e1fe0 88 package body APPS.FND_CP_FNDSM
0xfb36ec50 1 anonymous block
..."

The deadlock can also occur with the FND_CONCURRENT_REQUESTS table.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms