Numeric overflow or Arithmetic overflow error in Pay Confirmation (PY) (Doc ID 608124.1)

Last updated on MARCH 29, 2016

Applies to:

PeopleSoft Enterprise HCM Payroll for North America - Version 8 SP1 to 9.2 [Release 8 to 9]
Information in this document applies to any platform.

This document was previously published as Customer Connection Solution 258688




Symptoms

Pay Confirm abend -- "numeric overflow" -- fails in Balance Update processing with Log messages indicating some kind of overflow on numeric field.  The exact error message number and text will differ by DBMS platform -- some examples follow:

     ORACLE Log File Messages:

SQLRT:   EXECUTE-STMT 02212 Numeric overflow
at pos 00197
INSERT-OTH-SBAL 02212 Numeric overflow
PAGE#=00001,LINE#=001,SEPCHK=000,EMPLID={emplid},   EMPLRCD#0000,NAME=
PROCESS-CHECK(PSPSBUPD) 02212 Numeric overflow
MAIN(PSPPYUPD) 02212 Numeric overflow
MAIN(PSPPYWKS) 02212 Numeric overflow
PROCESS-CONFIRMATION(PSPPYWK1) 02212 Numeric overflow
Confirmation did not finish at XX:XX:XX.XX  !!!!!!

    SQL SERVER Log File Messages:

SQLRT: EXECUTE-STMT                                    08620 [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error converting numeric to type numeric. (SQLSTATE 22003) 8115
UPDATE-BALANCE                                         08620 PSODBC is unable to lock TaskInfo; PS_sqlerr(error=8620)
PAGE#= 793,LINE#= 7,SEPCHK=0,EMPLID={emplid}           ,EMPLRCD#=  0,NAME=                                                     
PROCESS-CHECK(PSPSBUPD)                                08620 PSODBC is unable to lock TaskInfo; PS_sqlerr(error=8620)
[ etc... ]

DB2 customer will abend with  Return Code: 08626  - Numeric value out of range. SQLSTATE=22003

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