My Oracle Support Banner

Fusion Global HR: User Entity PER_EXT_SEC_ASSIGNMENT_UE Is Fetching Multiple Rows in HCM Extract Instead of Returning the Latest Assignment Details from the Current (last) Work Relationship (Doc ID 2019572.1)

Last updated on NOVEMBER 14, 2023

Applies to:

Oracle Fusion Global Human Resources - Version 11.12.1.0.0 and later
Oracle Fusion Global Human Resources Cloud Service - Version 11.13.20.04.0 and later
Information in this document applies to any platform.
This note was created for Release 11.1.9.2.0. The note has been reviewed and is current for release 11.13.20.04.0.

Goal

The user wants to fetch only the latest assignment details from the current (last) work relationship although the person may have multiple work relationships in the past using the User Entity (UE) PER_EXT_SEC_ASSIGNMENT_UE.  But the UE is fetching multiple rows in the HCM Extract including the latest assignment row for the all work relationships belonging to one person.

Example: If a person got hired, 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.

Solution

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
Goal
Solution


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