Budget Funds Check Failed Due to Unexpected Error 'ORA-00060: deadlock detected while waiting for resource in Package PA_BUDGET_ACCOUNT_PKG Procedure Gen_Acct_All_Lines'.
(Doc ID 2901561.1)
Last updated on AUGUST 12, 2024
Applies to:
Oracle Project Costing - Version 12.2 to 12.2.12 [Release 12.2]Information in this document applies to any platform.
Symptoms
In R12.2.11, Funds check fails due to 'ORA-00060: deadlock detected while waiting for resource in Package PA_BUDGET_ACCOUNT_PKG Procedure Gen_Acct_All_Lines.'
ERROR
-----------------------
ORA-00060: deadlock detected while waiting for resource in Package PA_BUDGET_ACCOUNT_PKG Procedure Gen_Acct_All_Lines
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
- Log into a Projects Responsibility
- Navigate to Budgets
- Click Find Draft
- Click Details
- Change budget amount then save
- From Tools > Generate Budget accounting
- Submit Budget
- Review Budget Accounting
- Go to By Account(tab)-->Fund Check (B)
- Get the error message.
Changes
Upgraded to 12.2.11.
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 |
Changes |
Cause |
Solution |
References |