My Oracle Support Banner

Pension Processes Error: ORA-01455: Converting Column Overflows Integer Datatype (Doc ID 1665871.1)

Last updated on FEBRUARY 03, 2019

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).


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.