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.
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.
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".
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).
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms