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

Last updated on NOVEMBER 07, 2024

Applies to:

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

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.