GP_PAYAFTER RUNS TO NO SUCCESS WITH UNIQUE CONSTRAINT ERROR (Doc ID 2461832.1)

Last updated on JULY 21, 2023

Applies to:

Symptoms

STATEMENT:
========
Customer has a earning element for Casual payments which is PAY CASUALHR. This element has a defined User Field 1 assigned at the element level. This user key appears is populated via Positive Input and does result in multiple line entries in the payroll results. In this scenario, the employee has had a retrospective pay rate change which has resulted in the retrospective delta adjustments. This retro adjustment had resulted in 12 rows in the delta. To forward the retro delta adjustment to current month, element is added in Retro Process Overrides and selected Forward check box. Payroll Process GPPDPRUN went to success but GP_PAYAFTER process failed.

ERROR:
======
Error Position: 0 Return: 805 - ORA-00001: unique constraint (HNSS.PS_GP_RPTD_TMP7) violated

STEPS TO REPLICATE:
===================
The issue can be reproduced at will with the following steps:
1.Create a new variable to be assigned as a user field
2.Create a new earning and assign user field
3.Assign the new earning to the corresponding Element Group and Section
4.Enter multiple entries of the earning via Positive Input for the current open calendar and assign the user field
5.Calculate the current open calendar
6.Finalize the current open calendar
7.Apply a retrospective pay rate change as at the start of the prior finalized period
8.Add the new earning element in Retro Process Overrides page
9.Calculate the current calendar
10.The GP_PAYAFTER process runs to No Success due to Unique Constraint

Cause

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