3357699 - "Delta cannot be calculated for entity "paycomponent_non_recurring"" error when using CompoundEmployee API

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

• "COMPOND_EMPLOYEE/DELTA DUPLICATE KEYS"
  "Delta cannot be calculated for entity "paycomponent_non_recurring" because the image "Snapshot" has multiple records with the same business key (pay_component_code=XXX/pay_date=XXX/sequence_number=XXX)"
  

SAP SuccessFactors HCM Suite

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

Data inconsistency in the database

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.

COMPOND_EMPLOYEE,DELTA DUPLICATE KEYS, compoundemployee, compound employee, Delta cannot be calculated for entity, paycomponent_non_recurring, because the image, Snapshot, has multiple records with the same business key, query, error, delta mode, CompoundEmployee query, pay comp non recurring, pay component non recurring, Snapshot, pay_date, sequence_number, successfactors, sf, sfsf, sfapi , KBA , LOD-SF-INT-CE , Compound Employee API , Problem