My Oracle Support Banner

PAXACMPT:PRC: Update Project Summary Amounts Completed With Error “Ora-00060:Deadlock Detected” (Doc ID 2831477.1)

Last updated on JANUARY 10, 2022

Applies to:

Oracle Project Planning and Control - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When the process PAXACMPT: PRC: Update Project Summary Amounts is executed parallel for multiple operating units, the following error occurs:

ERROR
----------
MSG-00001: ORA-00060: deadlock detected while waiting for resource
MSG-00001: Debug Messages:
MSG-00001: proj_accum: Exception Generated By Oracle Error: ORA-00060: deadlock detected while waiting for resource
MSG-00001: Exception was generated by Accumulation API
REP-1419: 'beforereport': PL/SQL program aborted.
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1419: MSG-00001: Calling Maintain Project Accumulation

STEPS
-----------------------

The issue can be reproduced at will with the following steps:
1. Go to Project responsibility
2. Run the concurrent process PRC: Update Project Summary Amounts parallel for multiple operating units
3. Review the log file 

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.