Error "ORA-01403: no data found" While Executing API "HR_EX_EMPLOYEE_API.FINAL_PROCESS_EMP"
(Doc ID 2993005.1)
Last updated on DECEMBER 14, 2023
Applies to:
Oracle Human Resources - Version 12.2 HRMS RUP15 and laterInformation in this document applies to any platform.
Symptoms
When trying to execute the "HR_EX_EMPLOYEE_API.FINAL_PROCESS_EMP" API, following error appears
ERROR
Error report -
ORA-01403: no data found
ORA-06512: at "APPS.HR_EX_EMPLOYEE_API", line 2636
ORA-06512: at "APPS.HRENTMNT", line 8004
ORA-06512: at "APPS.HRENTMNT", line 1261
ORA-06512: at "APPS.HRENTMNT", line 1261
ORA-06512: at "APPS.HRENTMNT", line 5266
ORA-06512: at "APPS.HRENTMNT", line 7178
ORA-06512: at "APPS.HRENTMNT", line 7178
ORA-06512: at "APPS.HRENTMNT", line 7933
ORA-06512: at "APPS.PER_ASSIGNMENTS_F1_PKG", line 801
ORA-06512: at "APPS.PER_ASSIGNMENTS_F1_PKG", line 2780
ORA-06512: at "APPS.HR_ASSIGNMENT_INTERNAL", line 6741
ORA-06512: at "APPS.PER_ASG_DEL", line 361
ORA-06512: at "APPS.PER_ASG_DEL", line 907
ORA-06512: at "APPS.PER_ASG_DEL", line 1005
ORA-06512: at "APPS.PER_ASG_DEL", line 1069
ORA-06512: at "APPS.HR_ASSIGNMENT_INTERNAL", line 2691
ORA-06512: at "APPS.HR_EX_EMPLOYEE_API", line 2481
ORA-06512: at "APPS.HR_EX_EMPLOYEE_API", line 2481
ORA-06512: at line 8
01403. 00000 - "no data found"
*Cause: No data was found from the objects.
*Action: There was no data from the objects which may be due to end of fetch.
ORA-01403: no data found
ORA-06512: at "APPS.HR_EX_EMPLOYEE_API", line 2636
ORA-06512: at "APPS.HRENTMNT", line 8004
ORA-06512: at "APPS.HRENTMNT", line 1261
ORA-06512: at "APPS.HRENTMNT", line 1261
ORA-06512: at "APPS.HRENTMNT", line 5266
ORA-06512: at "APPS.HRENTMNT", line 7178
ORA-06512: at "APPS.HRENTMNT", line 7178
ORA-06512: at "APPS.HRENTMNT", line 7933
ORA-06512: at "APPS.PER_ASSIGNMENTS_F1_PKG", line 801
ORA-06512: at "APPS.PER_ASSIGNMENTS_F1_PKG", line 2780
ORA-06512: at "APPS.HR_ASSIGNMENT_INTERNAL", line 6741
ORA-06512: at "APPS.PER_ASG_DEL", line 361
ORA-06512: at "APPS.PER_ASG_DEL", line 907
ORA-06512: at "APPS.PER_ASG_DEL", line 1005
ORA-06512: at "APPS.PER_ASG_DEL", line 1069
ORA-06512: at "APPS.HR_ASSIGNMENT_INTERNAL", line 2691
ORA-06512: at "APPS.HR_EX_EMPLOYEE_API", line 2481
ORA-06512: at "APPS.HR_EX_EMPLOYEE_API", line 2481
ORA-06512: at line 8
01403. 00000 - "no data found"
*Cause: No data was found from the objects.
*Action: There was no data from the objects which may be due to end of fetch.
The issue can be reproduced at will with the following steps:
1. Login to Database.
2. Execute the API "hr_ex_employee_api.final_process_emp". An example is given below:
3. Encounter the above error
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |