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 APRIL 17, 2024
Applies to:
PeopleSoft Enterprise CS Student Financials - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
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
Rollback
Disconnect
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.
Changes
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! |
In this Document
Symptoms |
Changes |
Cause |
Solution |