My Oracle Support Banner

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 MAY 02, 2018

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.