My Oracle Support Banner

Budget Move/Need Summary Validation Error 00805 'unique constraint (SYSADM.PS_SFA_EA_STDNTAWD) violated' (Doc ID 2711558.1)

Last updated on SEPTEMBER 21, 2020

Applies to:

PeopleSoft Enterprise CS Financial Aid - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to run the batch budget move process, the following error occurs:

"ERROR: INSERT BATCH TMPAWD
 
Application Program Failed
 In Pgm Section : INSERT BATCH TMPAWD
 With Return Code: 00805
 Error Message : ORA-00001: unique constraint (SYSADM.PS_SFA_EA_STDNTAWD) violated"

The log shows the error occurs during the step to perform need summary validation, after the actual budget move step finished. Therefore, many or most of the budgets were likely updated. However, depending when the last COMMIT occurred prior to the error, some number of the new budgets will not have been saved.

Due to the problem being related to Need Summary Validation, the error can also be seen when running that batch process stand alone.

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
Cause
Solution


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