E-UPG: Data Conversion Step Failed with Error Position: 0 Return: 8601 - [IBM][CLI Driver][DB2] A CALCULATED OR DERIVED NUMERIC VALUE IS NOT WITHIN THE RANGE OF ITS OBJECT COLUMN (SQLSTATE 22003) -406 (Doc ID 2978158.1)

PeopleTools 8.60.05 - Application Engine
Copyright (c) 1988-2023 Oracle and/or its affiliates.
All Rights Reserved
Process 626073 resumed after step PTUPGCONVERT.MAIN.Process (108,538)
 Message Set Number: 108
 Message Number: 538
 Message Reason: Process 626073 resumed after step PTUPGCONVERT.MAIN.Process (108,538)
'UPGPT860AG' Program Started (226,2)
File: C:\PT860P05C_2304031456-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1851 Error Position: 0 Return: 8601 - [IBM][CLI Driver][DB2] A CALCULATED OR DERIVED NUMERIC VALUE IS NOT WITHIN THE RANGE OF ITS OBJECT COLUMN (SQLSTATE 22003) -406
Failed SQL stmt: INSERT INTO PSPTSF_GN_DSPRC (PTSF_SBO_NAME, PTSF_SRC_RECNAME, PTSF_SRC_FIELDNAME, PTSF_PRC_TYPE, PTSF_CONST_DATE) SELECT A.PTSF_SBO_NAME, B.RECNAME, 'EFFDT', 'CUR', NULLIF(CURRENT DATE,CURRENT DATE) FROM PSPTSF_RECORDS A, PSPTSF_SD SD, PSRECFIELDALL B WHERE SD.PTSF_SBO_NAME = A.PTSF_SBO_NAME AND SD.PTSF_SOURCE_TYPE = 'A' AND A.RECNAME = B.RECNAME AND B.FIELDNAME = 'EFFDT' AND CASE WHEN (CAST(2 AS DECIMAL)) = 0.0 THEN INT(CAST(USEEDIT AS DECIMAL)) ELSE MOD(INT(CAST(USEEDIT AS DECIMAL)) ,INT(CAST(2 AS DECIMAL))) END= 1 AND NOT EXISTS ( SELECT 'X' FROM PSPTSF_GN_DSPRC C WHERE C.PTSF_SBO_NAME=A.PTSF_SBO_NAME AND C.PTSF_SRC_RECNAME=A.RECNAME AND C.PTSF_SRC_FIELDNAME = 'EFFDT')

 Message Set Number: 200
 Message Number: 0
 Message Reason: File: C:\PT860P05C_2304031456-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1851 Error Position: 0 Return: 8601 - [IBM][CLI Driver][DB2] A CALCULATED OR DERIVED NUMERIC VALUE IS NOT WITHIN THE RANGE OF ITS OBJECT COLUMN (SQLSTATE 22003) -406
Failed SQL stmt: INSERT INTO PSPTSF_GN_DSPRC (PTSF_SBO_NAME, PTSF_SRC_RECNAME, PTSF_SRC_FIELDNAME, PTSF_PRC_TYPE, PTSF_CONST_DATE) SELECT A.PTSF_SBO_NAME, B.RECNAME, 'EFFDT', 'CUR', NULLIF(CURRENT DATE,CURRENT DATE) FROM PSPTSF_RECORDS A, (200,0)
Process 626073 ABENDED at Step UPGPT860AG.MAIN.InsDSPRC (SQL) -- RC = 8601 (108,524)
 Message Set Number: 108
 Message Number: 524
 Message Reason: Process 626073 ABENDED at Step UPGPT860AG.MAIN.InsDSPRC (SQL) -- RC = 8601 (108,524)

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