My Oracle Support Banner

User Entity PER_EXT_SEC_ASSIGNMENT_UE Fetching Multiple Rows. (Doc ID 2019572.1)

Last updated on JANUARY 18, 2020

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version and later
Information in this document applies to any platform.


On : version, Global Human Resources

User Entity PER_EXT_SEC_ASSIGNMENT_UE Fetching multiple rows.

We are using UE PER_EXT_SEC_ASSIGNMENT_UE in HCM extract. Our intention is to fetch the latest assignment details from the current(last) work relationship although the person may have multiple work relationship in past. However the UE PER_EXT_SEC_ASSIGNMENT_UE keeps on fetching the latest assignment row for the all work relationship belonging to one person.

Example: If a person got hired and terminated and again rehired then the UE is bringing two rows of data one for the terminated work relationship and another for the rehire work relationship.

Our understanding is that this UE PER_EXT_SEC_ASSIGNMENT_UE should always bring the latest row from the current work relationship and should not bring the data from his\her previous work relationship. Due to this issue we are getting unwanted rows in the output.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.