My Oracle Support Banner

HR_POSITION_API.CREATE_POSITION Gets Error ORA-20001 for Future Dated Positions (Doc ID 2537250.1)

Last updated on DECEMBER 04, 2019

Applies to:

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


Problem Statement:

When making a Web ADI call to HR_POSITION_API.CREATE_POSITION the following error occurs when p_effective_start_date > SYSDATE and the system profile HR: POSITION NAME is set to DATE EFFECTIVE:

ORA-20001: Error create position API:  -20001:ORA-20001: The mandatory argument name value cannot be null
Cause:        The mandatory argument name has either not been specified or has been explicitly set to null in the API   per_pos_bus.chk_name_unique_all_lang .  
Action:        Either specify a value for the name argument which is not null or contact your local support representative.


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

  1. Call the api hr_position_api.create_position

  2. Set p_effective_start_date > SYSDATE


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.