My Oracle Support Banner

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

Last updated on DECEMBER 09, 2022

Applies to:

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


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


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.

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


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.