Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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.
Comments
Post Details
Added on Jul 23 2019
#cloud-applications, #hcm-cloud-service
10 comments
779 views