My Oracle Support Banner

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 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

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).
 
Using UE:
- PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UE
Threading DBI: Extract Assignment ID
Threading Action Type: Object Actions

- PER_EXT_PAY_EMPLOYEES_UE

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?

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
Cause
Solution
References


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