If you attempt to run the Generate Salaries and Allowances job and it stalls, first review the relevant log file.
If the above error appears in the log, it is because of duplicate position or point records for the referenced employee.
To resolve this, you need to check for any duplicate records and remove them before running the job again. To do this, follow the steps below.
Generate log file
To generate the log file, follow the steps below in portal.
Click Manage Payroll then, for the relevant pay group, select Process Payroll.
Next to Generate Salaries and Allowances, click the three-dot menu.
Select View Log File then, on your keyboard, press Ctrl + F.
Enter ORA-.
If the same error appears, this is because the employee in the error message has multiple position/point rows with the same effective date and input date.
Remove duplicates
To remove the duplicate rows for the employee, follow the steps in the relevant section below.
⚠️Important: This screen is for use by non-post management customers only. Post management customers need to do this via PeopleXD People Management.
Portal
Click Manage Payroll then under the relevant pay group, click Inputs.
Click General.
Depending on the type of rate to delete, click either Maintain Employee Position/Point or Maintain Personal Rates.
Delete the duplicated record, then click Save.
Re-run the job.
Back Office
Click CorePay then select Pay Rates.
Click Maintain Employee Position and Point or Maintain Personal Rates as required.
Delete the duplicated record then rerun the job.