User Entity PER_EXT_SEC_ASSIGNMENT_UE Fetching Multiple Rows.
Last updated on NOVEMBER 18, 2015
Applies to:Oracle Fusion Global Human Resources Cloud Service - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
On : 126.96.36.199.0 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms