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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

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)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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