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.
When the process PAXACMPT: PRC: Update Project Summary Amounts is executed parallel for multiple operating units, the following error occurs:
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
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
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