SQL Error when opening Financial Aid components for 2015-2016 after loading ISIRs (Doc ID 1969876.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 loading 2015- 2016 ISIRs users are unable to open any component that uses the PS_STDNT_AWD_PER (either directly or as a view), such as View Packaging Status Summary. The user is presented with the following error online:

A SQL error occurred. Please consult your system log for details.

An error has occurred that has stopped this transaction from continuing.

The App Server Log file contains the following error:

[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, BDGT_DURATION_FED, BDGT_DURATION_INST, FANLTR_STATUS, FANLTR_STATUS_PREH, INST_CALC_SC, INST_CALC_PC, INST_CALC_EFC, ISIR_CALC_SC, ISIR_CALC_PC, ISIR_CALC_EFC, SFA_PELLYR_COA_LHT, COMMENTS FROM PS_STDNT_AWD_PER WHERE EMPLID=:1 AND INSTITUTION=:2 AND AID_YEAR=:3 ORDER BY EMPLID, INSTITUTION, AID_YEAR DESC, AWARD_PERIOD
PSAPPSRV.5236 (783) [2015-02-11T08:58:01.152 PS@dXXXXXX (IE 8.0; WIN7) ICPanel](0) An error has occurred which prevents this transaction continuing



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