SAP Knowledge Base Article - Public

2602841 - Duplicate rows in Integration Center output file.

Symptom

  • In the output CSV file from Integration center you are seeing duplicate Users.

Environment

  • Integration Center
  • Successfactors HCM Suite

Reproducing the Issue

  1. Execute the report manually or wait for scheduled run.
  2. Review the Output File for duplicates

Cause

This issue is usually caused by missing indexing on DB level.

Resolution

To fix this you will need to add a sort parameter in the Advanced Sorting section of Integration Center

Sorting.PNG

For best result it is advised to sort on a field which is a business key field.

You can find the business Keys listed in the OData Data Dictionary under the starting entity set for the Integration Center Integration

Keywords

Duplicate Records, Duplicates, Integration Center Export, Integration Center Output File, Duplicate Users , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , SF Integrations - EC Payroll, Boomi/ HCI, API , Problem

Product

SAP SuccessFactors HCM Core all versions