We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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

HCM Extracts - Getting Duplicates in Future Assignments

Accepted answer
17
Views
12
Comments
edited Nov 6, 2020 9:00AM in HCM Integrations 12 comments

Summary

Getting Duplicates in Future Assignments

Content

I need to fetch the Changes Only Person and Assignment data of all stated transactions(Past, current and future assignments). I'm using 'PER_EXT_SEC_HISTORY_ASSIGNMENTS_UE' to achieve the requirement. But getting duplicates in Future hire  and future assignments.

I'm using below filter criteria as per my requirement.

 1.Assignment Type  - 'E'

2.Legislation code = 'US' , 'CA'

3.Hourly_salaried_code = 'H'

 

But when I ran the UE Route query in BIP, I'm not getting duplicates. 

Please advise me to resolve the duplicates.

 

Thanks,

Keerthana.

Version

20 D

Code Snippet

 ( asg.assignment_type='E'
 AND asg.effective_latest_change = 'Y'
 AND asg.legislation_code IN ('CA', 'US')
 AND asg.hourly_salaried_code = 'H'
)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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