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 30, 2020

Applies to:

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

Symptoms

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:
<OBJECT_ACTION_ID>12195</OBJECT_ACTION_ID>
<OBJECT_ACTION_ID>12197</OBJECT_ACTION_ID>

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

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


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