Project Budget Baseline was Rejected and Budget Funds Check Errors: PA_BC_EVENTS_NOT_PROCESSED/PAPA_BC_XLA_ERROR/XLA_AP_INVALID_BUDGET_DATE and ORA-00060: deadlock detected while waiting for resource
(Doc ID 3027291.1)
Last updated on JULY 26, 2024
Applies to:
Oracle Project Costing - Version 12.2.7 and laterInformation in this document applies to any platform.
PAXBUEBU.fmb - Budgets Projects
Symptoms
When trying to check funds, from Budgets Projects form for the related Project Number using GL-Integrated Budget, click Details, from Review Budget Accounting, By Account (tab), then click on Check Funds button (B), get the below errors:
Unexpected error has occurred: 'ORA-00060: deadlock detected while waiting for resource in Package PA_BUDGET_ACCOUNT_PKG Procedure Gen_Acct_All_Lines'
Already applied Patch 33251815:R12.PSA.C from Doc ID 2901561.1.
When attempting to increase the budget and baseline the project budget, it is rejected with error, the form shows Rejected status and the notification shows the below error:
Description:
The following Projects budget integration has been processed with errors.
Project and Budget Information:
..
Comments:
PAPA_BC_XLA_ERROR
From FND log file, observed the below:
BEGIN of function validate_headers
BEGIN LOOP - invalid header
END LOOP - invalid headers
BEGIN of function validate_budgets
BEGIN LOOP - invalid budgets
LOOP invalid budgets: ae_header_id = ...
BEGIN of procedure BUILD_MESSAGE
p_appli_s_name = XLA
p_msg_name = XLA_AP_INVALID_BUDGET_DATE
...
psa.plsql.psapbcxb.psa_bc_xla_pub.Budgetary_Control 1 Call to Private API PSA_BC_XLA_PVT.Budgetary_control successful
pa.plsql.PA_BUDGET_FUND_PKG.Create_events_and_fundscheck 3 In Create_events_and_fundscheck: After Calling PSA_BC_XLA_PUB.Budgetary_Control
pa.plsql.PA_BUDGET_FUND_PKG.Create_events_and_fundscheck 3 In Create_events_and_fundscheck: l_return_status,l_result_status_code:S;XLA_ERROR
pa.plsql.PA_BUDGET_FUND_PKG.Create_events_and_fundscheck 3 In Create_events_and_fundscheck:Budgetary control API failed
pa.plsql.PA_BUDGET_FUND_PKG.Create_events_and_fundscheck 3 In Fail_draft_acct_summary
pa.plsql.PA_BUDGET_FUND_PKG.check_or_reserve_funds 3 Exception: WHEN OTHERS
pa.plsql.PA_BUDGET_FUND_PKG.check_or_reserve_funds 3 When Others:ORA-00060: deadlock detected while waiting for resource
...
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
11. Budget > Select the Project > Baseline
12. Get the error message: PAPA_BC_XLA_ERROR, as described above
Changes
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 |