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 11.13.20.04.0 and laterOracle 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 |