My Oracle Support Banner

Batch (FAPDISBS) or On-line Disbursement FETCH-AGGR Error (Doc ID 2273235.1)

Last updated on JANUARY 31, 2020

Applies to:

PeopleSoft Enterprise CS Financial Aid - Version 9 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : Campus Solutions 9.0 or later

When attempting to run batch or on-line disbursement,
the following error occurs.

ERROR
-----------------------
1) With batch processing: ERROR: FETCH-AGGR and then one of the following additional messages

a) ORA-00942: table or view does not exist

or

b) ORA-00001: unique constraint (SYSADM.PS_STDNT_AWRD_ACTV) violated

2) With online processing: Remote program FAPDISBR failed with reason: FETCH-AGGR (2,-1) DERIVED_SA.STDNT_DISB-PB.FieldChange PCPC:1439 Statement: 15




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. For Batch: Run batch disbursement

2. For on-line: Navigate to Disburse Aid. Click authorization then disbursement.

WHAT IS WORKING
-----------------------
The issue tends to be specific to individual students and item types, and does not affect most others.


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!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.