GP Core - Unique Constraint Error While Running GPGB_RTI_TRN (FPS) Process (Doc ID 2201429.1)

Last updated on NOVEMBER 07, 2016

Applies to:

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

Symptoms

When running the GPGB_RTI_TRN process for FPS, it is running to No Success as there is a unique constraint error on one of the SQL steps.

Replication steps
================
(1) An employee transfers between two paygroups (X to Y) in June 2015. This calendar group has a retro calendar from May 2015.
(2) In August 2016, this same employee moved back to the previous paygroup (Y to X).
(3) GPGB_RTI_TRN process runs and a SQL step is looking at the last time this employee was in X, which is June 2015.
(4) SQL step is picking up both calendar groups for June 2015 and May 2015, as June 2015 has the calendar period of May 2015 due to retro.
(5) SQL step is failing due to unique constraint violation due to picking up two calendar groups

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