My Oracle Support Banner

GPCHE: Error "INSERT or UPDATE would result in duplicate rows in a table with a UNIQUE index" When Running GPPDPRUN Process for Employees with more than 2 Source Tax Tariffs in One Calendar Year (Doc ID 2859821.1)

Last updated on MARCH 31, 2022

Applies to:

PeopleSoft Enterprise HCM Global Payroll Switzerland - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


GPPDPRUN process ends with following error for employees having more than 2 source tax tariffs in one Calendar year:

The issue can be reproduced at will with the following steps:
1. Navigation: Global Payroll & Absence Mgmt > Absence and Payroll Processing > Calculate Absence and Payroll
2. Go to the Process Monitor and note GPPDPRUN runs to 'No Success' with above error received


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

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