FA: Second step of Batch Budget assignment is failing at the FAPBUDPF_S_IAMT s (Doc ID 609437.1)

Last updated on APRIL 15, 2016

Applies to:

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

Information in this document applies to any platform.



This document was previously published as Customer Connection Solution 692733


Symptoms

  When running Batch Budget Assignment, the process fails with the following error message:

Error Encountered at: Fetch iamt

DIAGNOSIS:  From the trace . . .

2228       0.000  CUR #31    RC=0    Bind-1, type=SQLPBUF, length=3, value=PSUNV
2229       0.000  CUR #31    RC=0    Bind-2, type=SQLPBUF, length=4, value=2001
2230       0.000  CUR #31    RC=0    Bind-3, type=SQLPBUF, length=4, value=LOAN
2231       0.000  CUR #31    RC=0    Bind-4, type=SQLPBUF, length=4, value=UGRE
2232       0.009  CUR #31    RC=0    EXE
2233       0.003  CUR #31    RC=1    Fetch

There is no error message, just an RC=1. The RC=1 before the Fetch means that no row was returned for these values:  Institution = PSUNV, Aid Year =2001, BGT_ITEM_CATEGORY = LOAN and BUDGET_ITEM_CD = UGRE on  PS_BUDGET_ITEM_TBL. That's why the FAPBUDPF_S_IAMT fetch is failing.

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