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

(Doc ID 1983843.1)

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.

Symptoms

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 14.23.22.130000 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 .
Terminating Program.



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms