Running INAS causes a SQL error on Correct 2014-2015 ISIR Records (Doc ID 1960994.1)

Last updated on OCTOBER 05, 2016

Applies to:

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

Symptoms

After the application of Patch 18376494: UPDATES TO ISIR REJECT/COMMENT CODES AND ISIR/SAR CROSS REFERENCE FOR 2016, when running INAS on Correct 2014-2015 ISIR records or CS 9 Bundle #36,  the following messages appear online:

"A SQL error has occured.  Please consult you system log for details"

 

"Error in PeopleCode ScrollSelect processing (2,213) ISIR_CONTROL_INAS_RFC_CALL.FieldChange PCPC.2295 Statement 3"

They log file contains the following error:

PSAPPSRV.4516 (3508) [2015-01-12T15:58:11.191 XXXX@111.11.11.111 (IE 10.0; WIN7) ICPanel](3) File: E:\pt854l\peopletools\src\psppr\ramget.cppSQL error. Stmt #: 656  Error Position: 0  Return: 8602 - [Microsoft][SQL Server Native Client 11.0]Numeric value out of range (SQLSTATE 22003) 0
Failed SQL stmt: SELECT EMPLID, INSTITUTION, AID_YEAR, AWARD_PERIOD, FED_EFC, EFC_STATUS, INST_EFC, FED_NEED_BASE_AID, INST_NEED_BASE_AID, FED_YEAR_COA, INST_YEAR_COA, PELL_YEAR_COA, FED_NEED, INST_NEED, FED_UNMET_NEED, FED_OVRAWD_AMT, INST_UNMET_NEED, INST_OVRAWD_AMT, FED_PARENT_CONTRB, INST_PARENT_CONTRB, FED_STDNT_CONTRB, INST_STDNT_CONTRB, INST_EFC_OVERIDE, BASE_WEEKS, WEEKS_ENROLLED, WEEKLY_PC, WEEKLY_SC, PRORATED_EFC, FED_SPECIAL_AID, INST_SPECIAL_AID, FED_TOTAL_AID, INST_TOTAL_AID, FED_UNMET_COA, INST_UNMET_COA, FED_OVRAWD_COA, INST_OVRAWD_COA, VET_ED_BENEFIT, VET_ED_FAN_PRINT, PRORATED_PAR_CNTRB, PRORATED_STU_CNTRB, INST_DEPEND_STAT, FED_DEPEND_STAT, BDGT_DURATION_FED, BDGT_DURATION_INST, INAS_RULE_SET_INST, INAS_RULE_SET_FED, EFC_USE_IM FROM PS_STDNT_AWP_AIDVW WHERE EMPLID=:1 AND INSTITUTION=:2 AND AID_YEAR=:3 ORDER BY EMPLID, INSTITUTION, AID_YEAR DESC, AWARD_PERIOD
PSAPPSRV.4516 (3508) [2015-01-12T15:58:11.244 XXXX@111.11.11.111 (IE 10.0; WIN7) ICPanel](0) An error has occurred which prevents this transaction continuing

 

Changes

 Patch 18376494, posted after CS 9 Bundle #35 included some minor fixes around the Calc PC for Independent, including an updated FAPINAS5.cbl.

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