GP UK - Update End Date Court Order Process Runs To No Success
(Doc ID 2265281.1)
Last updated on MAY 02, 2018
Applies to:PeopleSoft Enterprise HCM Global Payroll UK - Version 9.2 and later
Information in this document applies to any platform.
GP UK - Update End Date Court Order process runs to No Success
When trying to run this process to carry out tests for bundling it runs to No Success
Due to fixes being supplied within the latest PUM images to which we are testing in relation to bundling, the process GPGB_CO_EDST ran to No Success becuase of this error:
PeopleTools 8.53.04 - Application Engine Server
Copyright (c) 1988-2017 Oracle and/or its affiliates.
All Rights Reserved
PSAESRV started service request at 16.09.52 2017-02-03
SQL error. Function: CreateSQL
Error Position: 0
Return: 8611 - [Microsoft][SQL Server Native Client 10.0][SQL Server]Error converting data type varchar to numeric. (SQLSTATE 37000) 8114
Statement: SELECT DISTINCT A.EMPLID, A.EMPL_RCD, A.GPGB_CO_ORDER, A.END_DATE, A.GPGB_CO_UPDTYPE FROM PS_GPGB_EE_CO_DTL A, PS_GPGB_EE_RSLT B WHERE A.UPDATE_ID = :1 AND A.EMPLID=B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND B.CAL_RUN_ID=:2 AND B.GP_PAYGROUP=:3
Original Statement: SELECT DISTINCT A.EMPLID, A.EMPL_RCD, A.GPGB_CO_ORDER, A.END_DATE, A.GPGB_CO_UPDTYPE FROM PS_GPGB_EE_CO_DTL A, PS_GPGB_EE_RSLT B WHERE A.UPDATE_ID = :1 AND A.EMPLID=B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND B.CAL_RUN_ID=:2 AND B.GP_PAYGROUP=:3
SQL error in Exec. (2,280) GPGB_CO_EDST.MAIN.GBL.default.1900-01-01.Step04.OnExecute PCPC:2639 Statement:26
Process 996038 ABENDED at Step GPGB_CO_EDST.MAIN.Step04 (PeopleCode) -- RC = 8 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
PSAESRV completed service request at 16.10.39 2017-02-03
Select the process via Main Menu>Global Payroll & Absence Management>Payee Data>Garnishments/Court Orders>Update End Date GBR and select a finalised calendar run id and run the process.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!