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.
Remove duplicate rows in HCM Extract
Summary:
Hello again, Customer Connect!
I am developing an HCM Extract for retrieving Benefit data. Currently I am using these two UE:
PER_EXT_SEC_PERSON_UE as Root
BEN_EXT_ENRT_RSLT_UE as Child
I am pulling information on my eText Template only about the Child(since I can't use this UE for Root) but the rows are returning duplicated, even if I use this filter criteria for the BEN_EXT_ENRT_RSLT_UE:
PL.name IN (SELECT DISTINCT PL.name FROM ben_pl_f PL)
AND PEN.pl_typ_id IN (SELECT DISTINCT PEN.pl_typ_id FROM BEN_PRTT_ENRT_RSLT PEN)
Tagged:
0