My Oracle Support Banner

Generate 1098-T Process Fails With Error 'ORA-12899: value too large for column "SYSADM"."PS_SF_1098_DTL"."SSN" (actual: 11, maximum: 9) ' (Doc ID 2748098.1)

Last updated on JANUARY 16, 2023

Applies to:

PeopleSoft Enterprise CS Student Financials - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


The Generate 1098-T process is failing for students that have not provided a SSN (Social Security Number) and the default format of the SSN is stored.

The insert into the SF_1098_DTL record shows an 11 character string, in the format XXX-XXX-XXXX is being inserted. The SSN field on this record is defined as 9 characters.

ORA-12899: value too large for column "SYSADM"."PS_SF_1098_DTL"."SSN" (actual: 11, maximum: 9)
EPO error pos=810

The issue can be reproduced at will with the following steps:

  1. Navigate to Student Financials, Taxes, Generate 1098-T;
  2. Select a run control;
  3. Populate the run control;
  4. Submit the process to the process scheduler.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.