FAPPKBKG Unique Constraint (SYSADM.PS_STDNT_AWD_PELL) Violated

(Doc ID 2346541.1)

Last updated on MAY 23, 2018

Applies to:

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

Symptoms

On : CS 9.0 or 9.2 Patch FA LEGISLATIVE - YEAR ROUND PELL BEING REINTRODUCED BY FSA

When attempting to run the 3rd step of mass packaging or mass REpackaging in live mode,
the following error occurs.

ERROR
-----------------------
Error W/FAPPKCTL !
SQL Error: INSERT PKGPELL
Application Program Failed
In Pgm Section : INSERT PKGPELL
With Return Code: 00805
Error Message : ORA-00001: unique constraint (SYSADM.PS_STDNT_AWD_PELL) violated


STEPS
-----------------------
The issue can be reproduced at will with the following steps (which can apply to REpackaging also):
1. Run mass packaging select
2. Run mass packaging assign plans
3. Run process mass packaging in simulation mode
4. Run process mass packaging in live mode

WHAT IS WORKING
--------------------------
The process works in simulation mode, before failing in live mode. Process also works when no Pell is packaged. Even with Pell, some students are successfully processed before a problem students causes the batch to fail.



Changes

 

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