EPY: Pay Confirm Fails With Error 'Unique Constraint (SYSADM.PS_PAY_DISTRIBUTN) Violated' When Partial Check Invoked (Doc ID 3054214.1)

Last updated on OCTOBER 18, 2024

Applies to:

Symptoms

Pay Confirmation fails with the following error:

Steps to Reproduce

1. Setup Requirement - No boxes are checked under the Canada or USA flag in Direct Deposit Controls page
       Navigation: Set Up HCM > Product Related > Payroll for North America > Payroll Processing Controls > Direct Deposit Controls
2. Before the new code was added to stop Priorities >= 900, an analyst updated an Employee's Direct Deposit from Remaining Balance to 'Amount' or 'Percent' with a Priority higher than 900 (example 998)
        Navigation: Payroll for North America > Employee Pay Data USA > Request Direct Deposit
3. Employee goes into Fluid Self Service and adds a new 'Remaining Balance' account (Priority is always 999)
        Navigation: Employee Self Service > Payroll > Direct Deposit
4. On another day, the Employee returns to Fluid Self-Service and changes the new 'Remaining Balance' to 'Amount' or 'Percent' but ensures the two accounts are below 100%
       a) This will create a check with the balance and the check priority will be set to 999
       b) The self-service will set the new priority of the 'Amount' or 'Percent' will also be at 999 because the Priority for the other account is set to 998
5. Payroll Creates Paylines
        Navigation Payroll for North America > Payroll Processing USA > Create and Load Paysheets > Create Paysheets
6. Payroll runs pay calculation
      Navigation: Payroll for North America > Payroll Processing USA > Produce Payroll > Calculate Payroll
7. Run Pay Confirm
      Navigation: Payroll for North America > Payroll Processing USA > Produce Payroll > Confirm Payroll
8. Process errors out, message appears in log file

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.