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 NOVEMBER 20, 2023
Applies to:
Oracle Human Resources - Version 11.5.10.2 and laterInformation in this document applies to any platform.
Symptoms
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:
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.
STEPS
--------
The issue can be reproduced at will with the following steps:
1. use a script to call the contact API
Cause
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
Symptoms |
Cause |
Solution |