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 MARCH 09, 2020
Applies to:PeopleSoft Enterprise HCM Global Payroll UK - Version 9.2 and later
Information in this document applies to any platform.
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.
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
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