Skip to main content

Error: 'ORA-00001: unique constraint (COREHR.EMP_PAY_HIST_IDX) violated'

The pay355 Complete Update job is stuck for a pay group, displaying the following error: ERROR: 'ORA-00001: unique constraint (COREHR.EMP_PAY_HIST_IDX) violated'

O
Written by Onyema Onyejekwe
Updated over 3 months ago

If you attempt to generate the pay355 Complete Update job and it gets stuck for a pay group, displaying the error message above, it's due to inconsistent SMP data records. This inconsistency is causing a duplication error when trying to insert data into the History tables.

To resolve this, support needs to run a script. Please raise a new case online and reference the title of this article. Include the following details:

  • Affected pay group

  • Payroll period

Did this answer your question?