Skip to Main Content

Cloud Platform

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

UE: PER_EXT_SEC_PERSON_UE is returning duplicates

2766599Jul 23 2019 — edited Aug 6 2019

Hi Team,

I am facing the same issue mentioned in Doc ID 1638495.1.

Here I don't see any issue with block criteria.

UE: PER_EXT_SEC_PERSON_UE

If a person has multiple relationships (EMP and PRTN), then extract is returning 4 rows instead of 2 rows.

Same OBJECT_ACTION_ID is repeating twice.

<OBJECT_ACTION_ID>14955</OBJECT_ACTION_ID>

<Person_Details>

<PerID>300000006637022</PerID>

<PerNumber>35982</PerNumber>

<OBJECT_ACTION_ID>14957</OBJECT_ACTION_ID>

<Person_Details>

<PerID>300000006637022</PerID>

<PerNumber>35982</PerNumber>

<OBJECT_ACTION_ID>14955</OBJECT_ACTION_ID>

<Person_Details>

<PerID>300000006637022</PerID>

<PerNumber>35982</PerNumber>

<OBJECT_ACTION_ID>14957</OBJECT_ACTION_ID>

<Person_Details>

<PerID>300000006637022</PerID>

<PerNumber>35982</PerNumber>

But if we run the UE query from database for that employee its returning only 2 rows as expected.

Thanks

Madhan.

Added on Jul 23 2019

#cloud-applications, #hcm-cloud-service

10 comments

1,287 views