GP UK - Update End Date Court Order Process Runs To No Success

(Doc ID 2265281.1)

Last updated on MAY 12, 2017

Applies to:

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

Symptoms

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

Replication steps
===============
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.

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