HR_ASSIGNMENT_API.UPDATE_EMP_ASG_CRITERIA throws ORA-20001: System Error: Procedure at Step 40 (Doc ID 1945587.1)

Last updated on SEPTEMBER 19, 2017

Applies to:

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

Symptoms

When the segment of People Group Key flexfield is not defined or not enabled, updating assignment information using API(hr_assignment_api.update_emp_asg_criteria) throws the following error.
  

ERROR at line 1:
ORA-20001: System Error: Procedure  at Step 40
Cause:        The procedure  has created an error at Step 40.
Action:        Contact your system administrator quoting the procedure  and Step 40.
ORA-06512: at "APPS.HR_ASSIGNMENT_API", line 17335
ORA-06512: at line 23

 



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Update assignment information using API(hr_assignment_api.update_emp_asg_criteria). Pass null or hr_api.g_number to the parameter "p_people_group_id".

Sample script


2. Error occurs.



OTHER INFO
--------------
The error does not occur when updating the same information on PUI(Full Installed HR - Assignment form, Shared HR - Person Information form -> Assignment tab).

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms