My Oracle Support Banner

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 AUGUST 06, 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; or when attempting to retrieve a packaging or re-packaging plan on-line, the following error occurs:

ERROR
-----------------------

BATCH:
"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"



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 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.



Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.