My Oracle Support Banner

ORA-12899: value too large for column "SYSADM"."PS_STDNT_AWD_PKG"."SFA_PKG_DEP_STAT" (actual: 3, maximum: 1) (Doc ID 2412481.1)

Last updated on JUNE 18, 2018

Applies to:

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

Symptoms

On : 9 version, Award Processing

When attempting to click the Validate button on the Award Entry page,
the following error occurs.

ERROR
-----------------------
Application Program Failed
 Action Type : SQL UPDATE
 In Pgm Section : SQLRT: EXECUTE-STMT
 With Return Code: 12899
 Error Message : ORA-12899: value too large for column "SYSADM"."PS_STDNT_AWD_PKG"."SFA_PKG_DEP_STAT" (actual: 3, maximum: 1)
 Stored Stmt : FAPPKCTL_U_ATMPAWD
 SQL Statement : UPDATE PS_STDNT_AWD_PKG SET AWARD_STATUS=:1 ,AWARD_SOURCE=:
  2 ,AWARD_ACTION=:3 ,OFFER_AMOUNT=:4 ,ACCEPT_AMOUNT=:5 ,NET_A
  WARD_AMT=:6 ,SCHEDULED_AWARD=:7 ,PKG_STATUS_CD=:8 ,LN_FEE_AM
  T=:9 ,NET_OFFER_AMT=:10 ,OFFER_LOAN_FEE=:11 ,ACCEPT_LOAN_FEE
  =:12 ,CANCEL_DECLINE_AMT=:13 ,PKG_PLAN_ID=:14 ,DRUG_OFFENSE_
  FLAG=:15 ,OFFER_REBATE_AMT=:16 ,ACCEPT_REBATE_AMT=:17 ,COMME
  NT_CODE=:18 ,SFA_PKG_DEP_STAT=:19 ,SFA_AGGR_SRC_USED=:20 WHE
  RE EMPLID=:21 AND INSTITUTION=:22 AND AID_YEAR=:23 AND PKG_S
  EQ_NBR=:24 AND ITEM_TYPE=:25 AND ACAD_CAREER=:26
 
  at pos 00390
  at pos 00390
  at pos 00390
  at pos 00390
  at pos 00390
  at pos 00390
  at pos 00390
  at pos 00390
  at pos 00390
  at pos 00390
  at pos 00390
  at pos 00390
  at pos 00390
  at pos 00390
  at pos 00390
  at pos 00390
  at pos 00390
  at pos 00390
  at pos 00390
  at pos 00390
  at pos 00390
  at pos 00390
  at pos 00390
  at pos 00390
  at pos 00390
  at pos 00390
  at pos 00390
  at pos 00390
  at pos 00390
 with return code: 2899 .Reason: ORA-12899: value too large for column "SYSADM"."PS_STDNT_AWD_PKG"."SFA_PKG_DEP_STAT" (actual: 3, maximum: 1). In section: SQLRT: EXECUTE-STMT
 
 
Error W/FAPPKCTL !
 
SQL Error: UPDATE ATMPAWD
 
 
Application Program Failed
 In Pgm Section : UPDATE ATMPAWD
 With Return Code: 12899
 Error Message : ORA-12899: value too large for column "SYSADM"."PS_STDNT_AWD_PKG"."SFA_PKG_DEP_STAT" (actual: 3, maximum: 1)
UPDATE ATMPAWD


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Financial Aid > Awards > Award Processing > Assign Awards to a Student
2. Click the Validate button


Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.