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:
- Navigate to Student Financials, Taxes, Generate 1098-T;
- Select a run control;
- Populate the run control;
- 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