My Oracle Support Banner

API 'HR_ASSIGNMENT_API.UPDATE_EMP_ASG_CRITERIA' Errors With ORA-20001 or ORA-01403 (Doc ID 2885153.1)

Last updated on FEBRUARY 08, 2023

Applies to:

Oracle Human Resources - Version 12.1 HRMS RUP9 and later
Information in this document applies to any platform.


Problem Statement:

When attempting to execute api hr_assignment_api.update_emp_asg_criteria,
the following error occurs.

Error 1

ORA-20001: System Error : Procedure Hr_entry_api.delete_element_entry At Step 1

Cause : The procedure hr_entry_api.delete_element_entry has created an error at Step 1.


Error 2

ORA-01403: no data found
ORA-06512: at "APPS.HR_ASSIGNMENT_API", line 16976
ORA-06512: at line 27
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.

Steps to Reproduce:

The issue can be reproduced at will with the following steps:

1. Login to SQL Developer or TOAD

2. Call api hr_assignment_api.update_emp_asg_criteria from wrapper code


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.