SAP Knowledge Base Article - Public

3239581 - SFAPI Compound Employee Delta Mode: COMPOUND_EMPLOYEE/DELTA_DUPLICATE_KEYS

Symptom

Delta cannot be calculated for entity "paycompensation_non_recurring" because the image "Snapshot" has multiple records with the same business key

 

Environment

  • SAP SuccessFactors HXM Suite
    • Compound Employee API

 

Reproducing the Issue

1. Run an API call against the Compound Employee API

2. Error appears in API response: Delta cannot be calculated for entity "paycompensation_non_recurring" because the image "Snapshot" has multiple records with the same business key

  

Cause

The user has two paycompensation_non_recurring with the same composite key.

  

Resolution

1. The Non Recurring Pay (EmpPayCompNonRecurring) composite key is made up of three properties from the table:

  2. Issue Date (payDate) DateTime
  3. User ID (userId) String(100)

2. When these properties are identical across multiple records the API is unable to determine which one should be returned in snapshot mode and throws awarning that two records with the same composite kep for that object exists.

3. Review the users profile and confirm there is two records with the same composite keys.

4. One of the records will have to corrected so the keys are not identical. Deleting it or updating the Issue date will resolve the issue.

  
 
 

Keywords

SFAPI, COMPOUND_EMPLOYEE/DELTA_DUPLICATE_KEYS  , KBA , LOD-SF-INT-CE , Compound Employee API , LOD-SF-INT , Integrations , Problem

Product

SAP SuccessFactors HCM suite all versions