FANSEL Error ORA-01438 (Doc ID 1630158.1)

Last updated on APRIL 20, 2016

Applies to:

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

Symptoms

 When running the FANSEL process, the following error is encountered:

ORA-01438 - "value larger than specified precision allowed for this column".

The error occurs in two known situations: 

1) Insert into R_FANLTR_BDGT, when the budget is > 99,999

2) Insert into R_FANLTR_STDNT, when the total efc is > 999,999

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