GP UK - Court Order Update End Date Fails With Duplicate Key Insert Error In GPGB_CO_RCP_TAG (Doc ID 2200440.1)

Last updated on NOVEMBER 03, 2016

Applies to:

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

Symptoms

The Court Order Update End Date app engine (GPGB_CO_EDST) fails in production because of a duplicate key insert error in GPGB_CO_RCP_TAG.
Without this process running, any rehires who had a court order in their previous employment will start having court order deductions made from their pay. This is incorrect, since the old court order should no longer be processed and a new court order must be issued in this scenario.

Error
=============
File: e:\pt85304c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1623 Error Position: 0 Return: 805 - [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.PS_GPGB_CO_RCP_TAG' with unique index 'PS_GPGB_CO_RCP_TAG'
Process 882009 ABENDED at Step GPGB_CO_EDST.Insert.Step01 (SQL) -- RC = 805 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
PSAESRV completed service request at 14.56.38 2016-08-08

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