HR_CONTRACT_API.CREATE_PERSON does not allow Gender Unknown and throws error ORA-20001: The entry for gender is not recognized. Check and re-enter M or F.
(Doc ID 353778.1)
Last updated on JUNE 16, 2022
Applies to:Oracle Human Resources - Version 220.127.116.11 and later
Information in this document applies to any platform.
When attempting to use the hr_contact_api.create_person api to load contacts to load all contacts with the unknown gender (U). The form allows this, but the API gives the following error:
Hr_contact_api.create_person does not allow gender unknown ora-20001
Error: SQLCODE=-20001 SQLERRM=ORA-20001: The entry for gender is not recognized. Check and re-enter M or F.
The issue can be reproduced at will with the following steps:
1. use a script to call the contact API
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