My Oracle Support Banner

ETL9.2- Arithmetic Overflow Error At TL_TA000900.GA000.Step020 For MSSQL Server (Doc ID 2521091.1)

Last updated on OCTOBER 07, 2019

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Time Admin is failing at step TL_TA000900.GA000.Step020 (SQL) with a SQL error on MSSQL Server databases.

ERROR
-----------------------
File: e:\pt857p04b_1901030800-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1725 Error Position: 0 Return: 8624 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Arithmetic overflow error converting expression to data type smallint.
[Microsoft][SQL Server Native Client 11.0][SQL Server]The statement has been terminated. (SQLSTATE 01000) 3621
Failed SQL stmt: INSERT INTO PS_TL_LEAVE_TAO51 (PROCESS_INSTANCE, SEQNUM, EMPLID, EMPL_RCD, DUR, TL_QUANTITY, PLAN_TYPE, MAX_NEG_HRS) SELECT A.PROCESS_INSTANCE, A.SEQ_NBR, A.EMPLID, A.EMPL_RCD, A.DUR, A.TL_QUANTITY, C.PLAN_TYPE, 0 FROM PS_TL_IPT151 A , PS_TL_TRC_TBL B , PS_EARNINGS_ACCRL C , PS_TL_ERNCD_TBL F , PS_EARNINGS_TBL H WHERE A.PROCESS_INSTANCE=:1 AND B.TRC=A.TRC AND B.COMP_LEAV_IND='LTKN' AND B.EFFDT=( SELECT MAX(B1.EFFDT) FROM PS_TL_TRC_TBL B1 WHERE B1.TRC=B.TRC AND B1.EFFDT<=A.DUR) AND F.TRC=A.TRC AND F.PAY_SYSTEM='NA' AND F.EFFDT=( SELECT MAX(G.EFFDT) FROM PS_TL_ERNCD_TBL G WHERE G.TRC=F.TRC AND G.PAY_SYSTEM='NA' AND G.EFFDT<=A.DUR) AND F.TL_ERNCD = C.ERNCD AND C.ERNCD=H.ERNCD AND C.EFFDT=H.EFFDT AND C.HRS_TAKEN_ADD='Y' AND H.EFFDT=( SELECT MAX(H1.EFFDT) FROM PS_EARNINGS_TBL H1 WHERE H1.ERNCD=H.ERNCD AND H1.EFFDT<=A.DUR)
2019-02-26-15.44.17.000762 GetNextStateRecord [68] Exception logged: RC=3.
2019-02-26-15.44.17.000763 ExecuteSql [1347] Exception logged: RC=8.
2019-02-26-15.44.18.000270 ExecuteSql [1466] Exception logged: RC=8.
2019-02-26-15.44.18.000271 DoSqlAction [2648] Exception logged: RC=8.
2019-02-26-15.44.18.000271 DoSqlAction [2697] Exception logged: RC=8.
2019-02-26-15.44.18.000271 DoStepActions [2035] Exception logged: RC=8.

Process 571457 ABENDED at Step TL_TA000900.GA000.Step020 (SQL) -- RC = 8624 (108,524)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Time Admin process

Cause

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
Symptoms
Cause
Solution
References


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