User Entity PER_EXT_SEC_ASSIGNMENT_UE Fetching Multiple Rows.

(Doc ID 2019572.1)

Last updated on NOVEMBER 18, 2015

Applies to:

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

Goal

On : 11.1.9.2.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.
 

Solution

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