NSLDS Files With Multiple Headers and Trailers in one file is causing the FAPTALRT cobol to fail with a unique constraint on PS_NSLDS_FAT_AGGR
Last updated on OCTOBER 05, 2016
Applies to:PeopleSoft Enterprise CS Financial Aid - Version 9 and later
Information in this document applies to any platform.
After applying CS 9 Bundle #36, when attempting to run the Process NSLDS Files (FAPTALRT) process, the following error occurs.
FAPTALRT - SQL ERROR IN SECTION: 20200-INSERT-NSLDS-AGGR (I-FATAGGR)
Application Program Failed
In Pgm Section : 20200-INSERT-NSLDS-AGGR (I-FATAGGR)
With Return Code: 00805
Error Message : ORA-00001: unique constraint (PSADMIN.PS_NSLDS_FAT_AGGR) violated
FAPTALRT - PERFORMING DATABASE ROLLBACK AT 22.214.171.124000 ON 2015-02-25
PTPSQLRT - Error Encountered
No longer have connection to DB due to an error from previous
action: SQL UPDATE. Bypassing current action: ROLLBACK .
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms