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

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.

Symptoms

When attempting to run consolidations in Periodic Processing for employees paid in payrolls that have over 9999 pages, the following error occurs:

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

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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms