GP_PAYAFTER RUNS TO NO SUCCESS WITH UNIQUE CONSTRAINT ERROR
(Doc ID 2461832.1)
Last updated on NOVEMBER 23, 2019
Applies to:PeopleSoft Enterprise HCM Global Payroll Core - Version 9.2 and later
Information in this document applies to any platform.
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 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
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