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

(Doc ID 2273235.1)

Last updated on JUNE 02, 2017

Applies to:

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


On : CS 9.0 or later

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

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

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


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

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.

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

The issue has the following business impact:
Due to this issue, users cannot disburse the aid for the affected student, and in the case of batch the error causes the entire process to halt, which could prevent other students from being disbursed also


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