My Oracle Support Banner

Fusion Global HR: Historical Position UE Returns Duplicate / Multiple Rows when Position Has Multiple Date Effective Records (Doc ID 2133383.1)

Last updated on JUNE 01, 2023

Applies to:

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


User has created a position extract using Historical Position User Entity (UE) PER_EXT_SEC_HISTORY_POSITION_UE.

The issue is that when a Position has multiple date effective records, the extract is duplicating the data and returning multiple rows.

The position has two date effective recordsand both are getting duplicated with different Object action ID:

Threading Action details on Extract are:
Threading Database Item - Extract Historical Position ID
Threading Action Type – Object Actions




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.