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:

Symptoms

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

Cause

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