Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UE returning duplicate rows for Employees with current and future
Summary
PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UE returning duplicate rows for Employees with current and future assignment recordsContent
Hi All,
Duplicate rows appear only for Employees with current and future assignment records, duplicates do not appear for only current or only future assignment records.
Please find details below:
Root UE: PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UE
Threading Database Item: Extract Assignment ID
Key Attributes: Extract Assignment ID, Assignment Effective Start Date, Assignment Effective Latest Change, Assignment Effective Sequence, Assignment Legal Employer ID, Period of Service ID
Test Case:
Today: 18th June 2019
The employee has an assignment update on the 19th of June 2019, a new position is being added
Tagged:
0