My Oracle Support Banner

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.

Symptoms

When attempting to submit Budget, the following error occurs.

ERROR
"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:
Navigation:
Responsibility: Projects
1. Budget -> (Menu) -> Tools -> Generate Budget Accounting

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.