ETL9.2: MSS TL_PAY_REVRS PROCESS Failed Due To Arithmetic Over Flow Error Converting Expression. (Doc ID 2590576.1)

Last updated on OCTOBER 16, 2019

Applies to:

Symptoms

On : 9.2 version, TL Integrations

When attempting to run reversal,
the following error occurs.

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

File: e:\pt85513b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1723 Error Position: 0 Return: 8603 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Arithmetic overflow error converting expression to data type int. [Microsoft][SQL Server Native Client 11.0][SQL Server]The cursor was not declared. (SQLSTATE 37000) 16945 Failed SQL stmt: SELECT A.SEQ_NBR ,COUNT(A.SEQ_NBR) + ((I.LAST_SEQ_PAY_TIME) * ( 1000000)) FROM PS_T L_PY_REV_WRK A ,PS_TL_PY_REV_WRK B ,PS_TL_INSTALLATION I WHERE A.PROCESS_INSTANCE = 1118005 AND A.PR OCESS_INSTANCE = B.PROCESS_INSTANCE AND A.SEQ_NBR <= B.SEQ_NBR AND A.PY_TL_REVRS_TYPE = 'D' GROUP BY A.SEQ_NBR,I.LAST_SEQ_PAY_TIME

Process 1118005 ABENDED at Step TL_PAY_REVRS.PROC_REV.New_Row (Do Select) -- RC = 8602

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run TL_PAY_REVRS Reversal 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.