FAPPKBKG Unique Constraint (SYSADM.PS_STDNT_AWD_PELL) Violated or Remote Program FAPPKRCL failed with reason: INSERT PKGPELL
(Doc ID 2346541.1)
Last updated on FEBRUARY 05, 2019
Applies to:PeopleSoft Enterprise CS Financial Aid - Version 9 and later
Information in this document applies to any platform.
On : Campus Solutions 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; or when attempting to retrieve a packaging or re-packaging plan on-line, the following error occurs:
"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"
ONLINE: "Remote Program FAPPKRCL failed with reason: INSERT PKGPELL"
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 OR auto-package student
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. With the on-line process, the issue only occurs very randomly and not in most cases.
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