FAPPKEAL External Awards Load Error 805

(Doc ID 2425099.1)

Last updated on JULY 19, 2018

Applies to:

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

Symptoms

On : CS 9 or 9.2

When attempting to run the batch external award load process, FAPPKEAL, an error occurs, indicated by some or all of the following messages:

ERROR
-----------------------
DYNAMIC SQL ERROR: 0000000805

IN MASS ACTION: FAEAEXOVRAW (Note: that is referring to the exclude equation on the run control, so could vary depending on the equation used)

SQL WAS ->INSERT INTO PS_SFA_EA_EXCLUDE( PROCESS_INSTANCE, EMPLID) VALUES ( :1, :2)
SQL ERROR TYPE IS DUPLICATE

FAPEQRUN - SQL ERROR IN SECTION: S-DYNAM(MASSACTN)

Application Program Failed
In Pgm Section : S-DYNAM(MASSACTN)
With Return Code: 00805
Error Message : ORA-00001: unique constraint (SYSADM.PS_SFA_EA_EXCLUDE) violated or Error Message : INSERT or UPDATE would result in duplicate rows in a table with a UNIQUE index

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Load records to staging table
2. Run FAPPKEAL

WHAT IS WORKING
--------------------------
The log indicates the process ran for awhile and executed parts successfully, before running into the problem



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