Pension Processes Error: ORA-01455: Converting Column Overflows Integer Datatype
Last updated on MAY 15, 2017
Applies to:PeopleSoft Enterprise HRMS 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).
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms