My Oracle Support Banner

12.2 Expenditure Mass Adjust Functionality Errors With ORA-01403 and ORA-06512 (Doc ID 2975990.1)

Last updated on SEPTEMBER 25, 2023

Applies to:

Oracle Project Costing - Version 12.2.7 and later
Information in this document applies to any platform.


When using the Mass Adjust option and select the adjustment Transfer, this will determine the program "PRC: Adjust Expenditure Items" to end with error.

ORA-01403: no data found
ORA-06512: at "APPS.PA_ADJUSTMENTS", line 8664

The issue can be reproduced at will with the following steps:
1- From a Project Super User Implementation responsibility
2- Go to Expenditure > Expenditure Inquiry
3- Enter the Project Number (and any other filters needed)
4- click on Mass Adjust button > select Transfer
5- will trigger the program "PRC: Adjust Expenditure Items" > which ends in error


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

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