Skip to main content

Error: 'Unable to update HR_PERSON_ESS_PARAMETER ORA-06502 numeric or value error...'

When viewing an employee on the Change Employee Reference screen the following error appears: character string buffer too small ORA 06512 at COREHR.PY_CHANGE_EMPLOYEE_REFERENCE line 48 ORA-00001 unique cons

O
Written by Onyema Onyejekwe
Updated over a month ago

If you encounter the above error message when trying to view employee details, this is because the background tables aren't populating as expected. This occurs because the job appears to have stopped during the process, leading to the CorePay tables being populated against the new employee number and the CorePersonnel tables still being populated against the old employee number.
​
To resolve this issue, support will need to run a script. Please raise a new case online referencing the title of this article. Include the following details:

  • A screenshot of the error.

  • The current employee number.

  • The new employee number

  • The change ID logfile (the path to this can be found in the file location section of the Change Employee Reference screen).

Did this answer your question?