Project Budget Funds Check Errors in The Form: PA_BC_EVENTS_NOT_PROCESSED and ORA-00060: deadlock detected while waiting for resource in Package PA_BUDGET_ACCOUNT_PKG Procedure Gen_Acct_All_Lines
(Doc ID 3069752.1)
Last updated on MARCH 18, 2025
Applies to:
Oracle Project Costing - Version 12.2.12 and laterInformation in this document applies to any platform.
Symptoms
Getting Error while clicking on Check Funds under Review Budget Accounting form:
Unexpected error has occurred: 'ORA-00060: deadlock detected while waiting for resource in Package PA_BUDGET_ACCOUNT_PKG Procedure Gen_Acct_All_Lines'
No errors in the log. This issue happens only for old projects created prior to upgrade. There is no issue with new projects.
The issue can be reproduced at will with the following steps:
1. Log into a Projects responsibility
2. Navigate to Budgets
3. Click Find Draft
4. Click Details
5. Change budget amount then save
6. From Tools > Generate Budget accounting
7. Submit Budget
8. Review Budget Accounting
9. Go to By Account(tab) > Fund Check (B)
10. Get the unexpected errors: 'PA_BC_EVENTS_NOT_PROCESSED' and 'ORA-00060: deadlock detected while waiting for resource, as described above
Changes
Upgrade from 12.1 to 12.2
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 |