Skip to main content

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

When running the payroll validation job, the following error appears.

O
Written by Onyema Onyejekwe
Updated over 3 months ago

If you run the payroll validation job and the following error appears, it is because an employee has changed pay groups between payroll process.

To resolve this, follow the steps below in Portal.

Review log file

Retrieve the log file to view the error. To do this, follow the steps below.

  1. Click Manage Payroll then highlight the relevant pay group.

  2. Click Process Payroll then click Payroll Validation.

  3. Click the three dot menu then click View Log File.

  4. Click Ctrl+F on your keyboard then look for error ORA- .

If the error displays COREHR.TEMP_PAY_PK, please raise a new case online and reference the title of this article. Include the following details:

  • Employee affected

  • Attach log file
    ​

Did this answer your question?