Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
HCM Extract - Extract Employee Contact Details when multiple contacts
Summary
HCM Extract - How to Extract Employee Contact Details when multiple contactsContent
Hi
In one of the HCM Extracts we are extracting Employee Contacts. The user entity which we are using is PER_EXT_CONTACT_RELATIONSHIPS_UE.
When the data is extracted for an employee and if that employee has multiple contacts, when we extract Contact Person Number using the Extract Contact Person Number DBI it is giving both the person numbers in the same field result.
This is doing the same thing for phones, emails as well.
Not sure if i should be using any conditions or filters something like primary contact. the contacts which we have converted so far they do not have a primary flag.
1