Fusion Global HR: HCM Data Extract Returning Duplicated Records
(Doc ID 2188840.1)
Last updated on APRIL 08, 2019
Applies to:Oracle Fusion Global Human Resources Cloud Service - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
HCM Data Extract returning duplicated records
We are using HCM Data Extract to extract records for existing employees that have any change(Salary , Name, Address...) and also to extract new/rehired EEs. This extract applies only for EEs that belong to specific Payroll (Name).
Threading DBI: Extract Assignment ID
Threading Action Type: Object Actions
Connecting Data Groups:
PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UE.Extract Assignment ID = PER_EXT_PAY_EMPLOYEES_UE.Extract Employee Assignment ID
Fitering: on Assignment (PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UE)
Extract Assignment Type = 'E'
And ( Extract Assignment Action = 'HIRE' Or Extract Assignment Action =
'TRANSFER' Or Extract Assignment Action Is Like 'REHIRE%' )
When extract is submitted it returns duplicate rows for same employee (but this does not happen for all employees).
What other criteria need to add to avoid this issue?
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