ETL9.2:Arithmetic overflow Error At TL_TA000600.XA000.Step020 (Doc ID 2291187.1)

Last updated on OCTOBER 17, 2017

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Time Administration

SQL error in TL_TIMEADMIN after HR upgrade to 9.2

ERROR
-----------------------




The following SQL error received in TL_TIMEADMIN while testing for 9.2 HR upgrade.
Log file is attached as well.
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1723 Error Position: 0 Return: 8646 - [IBM][CLI Driver][DB2/AIX64] SQL0802N Arithmetic overflow or other arithmetic exception occurred. SQLSTATE=22003
 (SQLSTATE 22003) -802
Failed SQL stmt: UPDATE PS_TL_PMTCH1_TMP2 SET MINUTES = :1 * TRUNC(((MINUTES + :2 + :3 - :4) / :5), 0) - :6, MINUTES2 = :7 * TRUNC(((MINUTES2 + :8 + :9 - :10) / :11), 0) - :12 WHERE PROCESS_INSTANCE = :13

Process 1759012 ABENDED at Step TL_TA000600.XA000.Step020 (SQL) -- RC = 8646 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run time admin and above error is encountered.

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