Remove duplicate rows in HCM Extract
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)