Issue applying CS 9.2 PRP 24301640: 2017 - 2018 AID YEAR UPDATES FOR DIRECT LENDING COD

(Doc ID 2246206.1)

Last updated on MAY 04, 2017

Applies to:

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

Symptoms

In Campus Solutions 9.2, after applying PRP 24301640: 2017 - 2018 AID YEAR UPDATES FOR DIRECT LENDING COD, not all the bugs resolved in the PRP have been included.  This can manifest in several ways such as...

 

When running Originate Pell Payment, the process is failing with the error....

Application Program Failed
Action Type : SQL UPDATE
In Pgm Section : SQLRT: EXECUTE-STMT
With Return Code: 08075
Error Message : An unsupported parameter datatype was specified
Stored Stmt : FAPPLBL0_I_DISBMNT
SQL Statement : INSERT INTO PS_PELL_DISBMNT (EMPLID ,INSTITUTION ,AID_YEAR ,
  PELL_ORIG_ID ,PELL_DISB_SEQ_NBR ,ACAD_CAREER ,ITEM_TYPE ,DIS
  BURSEMENT_ID ,PELL_DISB_AMT ,PELL_DISB_DT ,PELL_DISB_STATUS
  ,PELL_DISB_STAT_DT ,AWARD_PERIOD ,PELL_YTD_DSB_AMT ,ACTION_C
  ODE ,PELL_PAYPR_NBR ,PELL_PAYPR_STRT_DT ,PELL_PAYPR_END_DT ,
  PELL_PAY_PERIODS ,PELL_PAYPR_AMOUNT ,PELL_PAYPR_ACD_CAL ,PEL
  L_PAYPR_PMT_MTH ,PELL_PAYPR_COA ,PELL_PAYPR_ENRL_ST ,PELL_PA
  YPR_WEEKS ,WEEKS_PROG_ACADYR ,PELL_PAYPR_HOURS ,HRS_CREDITS_
  ACADYR ,PG_ED_USE_FLAG_1 ,PG_ED_USE_FLAG_2 ,PG_ED_USE_FLAG_3
  ,PG_ED_USE_FLAG_4 ,PG_ED_USE_FLAG_5 ,PG_ED_USE_FLAG_6 ,PG_E
  D_USE_FLAG_7 ,PG_ED_USE_FLAG_8 ,PG_ED_USE_FLAG_9 ,PG_ED_USE_
  FLAG_10 ,PELL_RFMS_DISB_SEQ ,PELL_PREV_DISB_REG ,PELL_DISB_T
  YPE ,PELL_COD_DISB_NUM ,PELL_COD_DISB_SEQ ,PELL_COD_DISB_AMT
  ,SFA_COD_ENR_SCHLCD ,CIP_CODE ,SFA_PROG_LENGTH_YR ,SFA_PROG
  _LENGTH_MN ,SFA_PROG_LENGTH_WK ,SFA_WK_PROG_ACADYR ,SFA_SPEC
  _PROG_FLG ,SFA_COD_CRED_LVL ,SFA_TRNS_PAYPERSDT ,SFA_TRNS_SU
  LA_LOAD ,SFA_TRNS_CIP_CODE ,SFA_TRNS_PROGLN_YR ,SFA_TRNS_PRO
  GLN_MN ,SFA_TRNS_PROGLN_WK ,SFA_TRNS_WKPRGACYR ,SFA_TRNS_SPP
  RG_FLG ,SFA_TRNS_COD_CRDLV ) VALUES (:1,:2,:3,:4,:5,:6,:7,:8
  ,:9,:10 ,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20 ,:21,:22,:2
  3,:24,:25,:26,:27,:28,:29,:30 ,:31,:32,:33,:34,:35,:36,:37,:
  38,:39,:40 ,:41,:42,:43,:44,:45,:46,:47,:48,:49,:50 ,:51,:52
  ,:53,:54,:55,:56,:57,:58,:59,:60 ,:61)


Application Program Failed
In Pgm Section : INSERT-PELL-DISBMNT
With Return Code: 08075
Error Message : An unsupported parameter datatype was specified

OR

Message Catalog entries are missing relating to Pell

NOTE: This issue does not result in missing Menu Items. No updated Menu Items were delivered in this PRP.  Please refer to  Missing 2016-2017 Aid Year Menu Items in CS 9.2 Financial Aid Module Note 2258985.1

 

 

 

 

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