Pension Processes Error: ORA-01455: Converting Column Overflows Integer Datatype
(Doc ID 1665871.1)
Last updated on JUNE 07, 2023
Applies to:PeopleSoft Enterprise HCM Pension Administration - Version 9.1 and later
Information in this document applies to any platform.
When attempting to run consolidations in Periodic Processing for employees paid in payrolls that have over 9999 pages, the following error occurs:
Application Program Failed
Action Type : SQL SELECT
In Pgm Section : SQLRT: EXECUTE-STMT
With Return Code: 01455
Error Message : ORA-01455: converting column overflows integer datatype
Stored Stmt : PAPPCHRS_S_GTCSPL2
SQL statement text not available.
See the SQL trace for statement text
when this cursor was last compiled.
The issue can be reproduced at will with the following steps:
1. Run consolidations of earnings, hours or contributions through Periodic Processes (Navigtion: Pension > Periodic Processes > Request Process).
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