GP: ORA-01438 Error When Running GP_PAYE.

(Doc ID 2365874.1)

Last updated on FEBRUARY 26, 2018

Applies to:

PeopleSoft Enterprise HCM Global Payroll Core - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, General

GP_PAYE PSJob process remain in processing status due the error in GP_PAYAFTER Application Engine:

ERROR
-----------------------
PeopleTools 8.56.03 - Application Engine Server
Copyright (c) 1988-2018 Oracle and/or its affiliates.
All Rights Reserved


PSAESRV started service request at 10.06.38 2018-02-20


Processo 138161 reiniciado após o passo GP_PAYAFTER.MAIN.[start] (108,538)

File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1725 Error Position: 315 Return: 1438 - ORA-01438: value larger than specified precision allowed for this column
Failed SQL stmt: INSERT INTO PS_GP_CS_STAT_STG(CAL_RUN_ID , GP_PAYGROUP , CAL_ID , USER_KEY1 , USER_KEY2 , USER_KEY3 , CALC_TYPE , PIN_GROSS_VAL , PIN_NET_VAL , RSLT_VER_NUM , RSLT_REV_NUM , GP_CS_STATUS , XLATLONGNAME , GP_AGGR_COUNT) SELECT A.CAL_RUN_ID , A.GP_PAYGROUP , A.CAL_ID , 'ACUM_RSLT' , TO_CHAR(A.PIN_NUM) , ' ' , ' ' , SUM(A.CALC_RSLT_VAL) , 0 , 0 , 0 , ' ' , ' ' , 0 FROM PS_GP_RSLT_ACUM A , PS_GP_PYE_PRC_STAT B , PS_GP_CAL_RUN_VW C WHERE A.CAL_RUN_ID = '2018/02 FP MENSAL' AND A.EMPLID = B.EMPLID AND A.CAL_RUN_ID = B.CAL_RUN_ID AND A.EMPL_RCD = B.EMPL_RCD AND A.GP_PAYGROUP = B.GP_PAYGROUP AND A.CAL_ID = B.CAL_ID AND A.ORIG_CAL_RUN_ID = B.ORIG_CAL_RUN_ID AND A.RSLT_SEG_NUM = ( SELECT MAX(SUB.RSLT_SEG_NUM) FROM PS_GP_RSLT_ACUM SUB WHERE A.EMPLID = SUB.EMPLID AND A.CAL_RUN_ID = SUB.CAL_RUN_ID AND A.EMPL_RCD = SUB.EMPL_RCD AND A.GP_PAYGROUP = SUB.GP_PAYGROUP AND A.CAL_ID = SUB.CAL_ID AND A.ORIG_CAL_RUN_ID = SUB.ORIG_CAL_RUN_ID) AND C.CAL_RUN_ID = A.CAL_RUN_ID AND C.GP_PAYGROUP = A.GP_PAYGROUP AND C.CAL_ID = A.CAL_ID AND B.CALC_TYPE = 'A' GROUP BY A.CAL_RUN_ID , A.CAL_ID , A.GP_PAYGROUP , A.PIN_NUM

O processo 138161 foi INTERROMPIDO na Etapa GP_CS_STAT.STAT.Ins_Acum (SQL) - RC = 1438 (108,524)

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

PSAESRV completed service request at 10.07.49 2018-02-20

Changes

 

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