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.
Can we achieve feature like outer-join in HCM extracts ?
Summary
Can we achieve feature like outer-join in HCM extracts ?Content
Hi,
Can we achieve feature like outer-join in HCM extracts ?
Just to give a background: We have a Employees UE, Assignments UE, Payroll UE and Element Entries UE.
Employee UE Root --> Thread Database item: PErson_id --> Next Connect --> Assignment UE, ---> Next connect --> Payroll UE --> Next Connect --> Element Entries UE. Right now, after joining, we get only those employees who has payroll attached.
We need a outer-join kind of feature where also those employees come up who do not have payroll attached . Kindly advise.
0