SAP Knowledge Base Article - Public

3357699 - Running compound employee returns DELTA_DUPLICATE_KEYS for non recurring pay component

Symptom

You are running the compound employee query and for one specific user it is failing with the following message:

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

  • Employee Successfactors
  • SFAPI - Compound Employee

Reproducing the Issue

  1. Go to any tool you are using to perform API queries
  2. Run the Compound Employee Query
  3. Get the error in the result of the query

Cause

Data inconsistency in the database

Resolution

If you encounter this issue, please log a ticket to LOD-SF-INT-CE since there is a chance that it will be required a script execution to fix the data.

As a pre requisite, please make sure that before creating the ticket you have the following information:

  1. SuccessFactors Company ID and support access. If you don't know how to provide the support access, please refer to the KBA below:
    2088892 - How to Grant Support Access to SuccessFactors Support Staff 
  2. Follow the KBA below to enable the payload logs and then reproduce the issue:
    2694943 - How to download API logs on SuccessFactors
  3. Provide the SFAPI payloads with the error in the ticket.

**FOR INTERNAL STAFF ONLY: Refer to internal notes for example.

Keywords

KBA , LOD-SF-INT-CE , Compound Employee API , Problem

Product

SAP SuccessFactors HXM Suite all versions