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

PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UE giving duplicate output

Received Response
39
Views
4
Comments

Summary:

We have a requirement to fetch future, past dated current effective records. I am using the UE PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UE As child and root is PER_EXT_SEC_PERSON_NOW_FUTURE_UE. But i am getting duplicate rows for same effective dates and assignment type.

What else should i add in the strcture to suppress duplicates

Content (please ensure you mask any confidential information):


Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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