GP UK: The Auto Enrolment Process is Enrolling Leavers After Termination or Fails with error "ORA-00001: unique constraint (SYSADM.PS_GPGB_EE_PENSION) violated". (Doc ID 2825649.1)

Last updated on DECEMBER 02, 2021

Applies to:

Symptoms

In the UK, the auto-enrolment process includes the automatic enrolment of all qualifying employees into a qualifying pension scheme.

An employee’s workplace pension is a way of saving for retirement arranged through the employer.

Whenever the auto enrolment process is run, the process updates the event and status corresponding to the process run date in the events table.

Issue 1: In this case when a payee is terminated with an effective date of current open calendar,  the auto enrolment process is adding termination event correctly.

However,  a subsequent run of the process for the same calendar period is attempting to enrol the employee again. 

Steps to replicate the issue: 

1. Select the active employee and ensure the employee is auto enrolled

 Global Payroll & Absence Mgmt > Payee Data > Pension Information > Assign Scheme GBR > Assign Scheme GBR

2. Terminate employee effective start of next calendar period

Workforce Administration > Job Information > Job Data

3. Run employee through payroll for current calendar

Global Payroll & Absence Mgmt> Absence and Payroll Processing> Calculate Absence and Payroll

4. Run Auto-enrolment

Global Payroll and Absence Mgmt > Absence and Payroll Processing > Pension Auto Enrollment GBR Auto Pension Enrollment GBR

5. Verify data on page “Assign Scheme GBR “

Global Payroll & Absence Mgmt> Payee Data > Pension Information > Assign Scheme GBR > Assign Scheme GBR

6. Run Auto-enrolment again

Global Payroll and Absence Mgmt > Absence and Payroll Processing > Pension Auto Enrollment GBR Auto Pension Enrollment GBR

Postponement row added in error.

Issue 2: Auto enrolment process fails with the following error : 

Steps to replicate the issue: 

1.Finalize payroll from Issue 1, step 3

 Global Payroll & Absence Mgmt> Absence and Payroll Processing> Calculate Absence and Payroll

2. Identify/Calculate next payroll

Global Payroll & Absence Mgmt> Absence and Payroll Processing> Calculate Absence and Payroll

3. Run auto-enrolment

Global Payroll and Absence Mgmt > Absence and Payroll Processing > Pension Auto Enrollment GBR Auto Pension Enrollment GBR

4. Select employee who has been auto enrolled and for whom the payroll was run

5. Terminate employee with an effective date

Workforce Administration > Job Information > Job Data

6. Run payroll

Global Payroll & Absence Mgmt> Absence and Payroll Processing> Calculate Absence and Payroll

7. Run auto-enrolment

 Global Payroll and Absence Mgmt > Absence and Payroll Processing > Pension Auto Enrollment GBR Auto Pension Enrollment GBR

Notice the program runs to No Success with the above error, as the process is trying to insert the auto-enrolment event/scheme again.

Changes

Cause

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