Skip to main content

Error: No Data Found when viewing applicants for a vacancy

An error displays similar to below: ORA-01403: no data found!!ORA-06512: at 'COREHR.ERQ_VACANCY_APPLICANTS_API' line 588\nORA-06512: at 'COREHR.ERQ_VACANCY_APPLICANTS_API' line 588\n

Debs avatar
Written by Debs
Updated over a month ago

The applicants usually display in alphabetical order and the error usually displays
for the impacted applicant. No other applicants will display after the impacted applicant.
​
​This error can display in the following scenario:
The applicant is an internal applicant i.e. has personnel_no populated in pers_applicant.
A record should exist in hr_person for this personnel_no.
If it does not exist, then this error will display.
This can occur when the employee record in hr_person has been removed in People Management, ACTIONS, Delete Person. This can be checked in the audit.
​
To resolve the personnel_no can be set to NULL on relevant tables.

Did this answer your question?