R12 Unable To Submit Project Budget Due to Error: ORA-01422: exact fetch returns more than requested number of rows / ORA-20002: 3136: Item 'PABDACWF/#SYNCH' cannot be accessed
(Doc ID 2187706.1)
Last updated on SEPTEMBER 16, 2022
Applies to:Oracle Project Costing - Version 12.1.3 and later
Information in this document applies to any platform.
When attempting to submit Budget, the following error occurs.
"ORA-01422: exact fetch returns more than requested number of rows in Package PA_BUDGET_ACCOUNT_PKG Procedure Derive_Resource_Params"
"ORA-20002: 3136: Item 'PABDACWF/#SYNCH' cannot be accessed while synchronous process in progress. in Package PA_BUDGET_ACCOUNT_PKG Procedure Gen_Acct_Line"
"Error generating account for the budget lines"
Error message in wfstatus.sql output:
ERROR_MESSAGE ABCD_PROJECT_ORG_DEPARTMENT FAILED
STEPS TO REPRODUCE
The issue can be reproduced at will with the following steps:
1. Budget -> (Menu) -> Tools -> Generate Budget Accounting
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