Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UE giving duplicate output
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):
Tagged:
0