Stored Statement FAPINAS9_S_FEDEXT not found in database

(Doc ID 2326277.1)

Last updated on NOVEMBER 08, 2017

Applies to:

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

Symptoms

After Applying CS 9.2 Patch 25997709: 2018 - 2019 AID YEAR UPDATES FOR ISIR, when running the ISIR Load (FAPSAR00) process, the following error is encountered:

CALLING FAPINAS9

Application Program Failed
Action Type : SQL SELECT
In Pgm Section : SQLRT: SQL-STMT-GET
Error Message : Stored Statement FAPINAS9_S_FEDEXT not found
Stored Stmt : FAPINAS9_S_FEDEXT

Error W/FAPINAS9 !

SQL Error: SELECT-FEDEXT(SELECT)

Application Program Failed
In Pgm Section : SELECT-FEDEXT(SELECT)

PTPSQLRT - Error Encountered
No longer have connection to DB due to an error from previous
action: SQL SELECT. Bypassing current action: SQL SELECT.
Terminating Program.

 

Obtaining a cobol sql trace of the FAPSAR00 process displays the following:

11:58:56.049 3178 0.016 0.000 #43 RC=1 GETSTMT Stmt=FAPINAS9_S_FEDEXT (failed)
11:58:56.061 3179 0.000 0.000 #43 RC=1 ERROR: Stored Statement FAPINAS9_S_FEDEXT not found in database.
11:58:56.096 3180 0.047 0.000 #43 RC=0 EPO error pos=0
11:58:56.101 3181 0.000 0.000 #43 RC=0 Rollback
11:58:56.106 3182 0.000 0.000 #43 RC=0 Disconnect
11:58:56.213 3183 0.109 0.000 #42 RC=0 EPO error pos=0
11:58:56.217 3184 0.000 0.000 #42 RC=0 Rollback
11:58:56.223 3185 0.016 0.000 #42 RC=0 Disconnect
11:58:56.227 3186 0.000 0.000 #41 RC=0 EPO error pos=0
11:58:56.230 3187 0.000 0.000 #41 RC=0 Rollback

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