What's new in Customer Journeys?

Connect and learn more! ×
Remove duplicate rows in HCM Extract — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Remove duplicate rows in HCM Extract

Accepted answer
79
Views
6
Comments

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)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!