Fusion Global HR: HCM Data Extract Returning Duplicated Records (Doc ID 2188840.1)

Last updated on DECEMBER 10, 2016

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

On : 11.1.11.1.0 version, Global Human Resources

ACTUAL BEHAVIOR
---------------
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).
 
We are 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 we need to add to avoid this issue?
 
EXPECTED BEHAVIOR
-----------------------
Extract should not return duplicate rows

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run extract
2. See that it returns duplicate rows

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, extract returns duplicate rows.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms