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_PERSO_UE is returning duplicates
Content
Hi All,
We have an interface where we are using PER_EXT_SEC_PERSON_UE as Root data block as well as we are also using threading on this data block.
We have used System person type in ('EMP', 'CWK') so we are not getting any duplicates for a person with one Work Relationship or same type of WR(e.g- An associate had a EMP type WR with organisation before and now we are adding one more WR for this person which is also of type EMP)
We are getting dupicates for the person record where a person has both type of WR (EMP and CWK) with the organisation.
Tagged:
0