Get Started with Redwood for Oracle Cloud HCM Begin Now
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