Symptom
SFAPI Compound Employee Query does not retrieve multiple events included on the same day.
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
- SuccessFactors Employee Central HCM HXM Suite
- SFAPI CompoundEmployee
Reproducing the Issue
1. Make multiple changes on any employee on the same day (Note that every change made on the same day will be described as "3 of 4", "4 of 4"):
2. Run a Query and try to retrieve the information on the record 3 of 4, the responde will be like the below example, you can only see the last sequence number for all the changes made on that day:
Cause
Each record has a transaction sequence number. The record with the highest sequence number contains the business data for the time slice. Only the job data or compensation data of the time slice with the highest sequence number is considered.
Resolution
You can see the changes made on the Employee Central UI, but Compound Employee Queries does not inform all the changes made on a day by default.
You can only see the record of the last sequence number, that's the expected behavior of Compound Employee. If you use Delta on the Query, you will see how many sequence number you had on a day, but you can't get the information of each one.
This information is on the Work Book: Implementing the Employee Central Compound Employee API in Delta Transmission Mode, you can check on the link below on the see also section.
As a workaround you can retrieve the information using OData, you can get the information from the same entity the record for each sequence number for the above example.
Another workaround is in the SFAPI CompoundEmployee the parameters allJobChangesPerDay and allCompensationChangesPerDay (also segmentsForEnhancedEffectiveEndDateFilter) of the Implementing the Employee Central Compound Employee API handbook.
See Also
Keywords
Compound Employee Query does not retrieve multiple events included on the same day, only last sequence number compound employee, compound employee sequence number, sequence number, last sequence number, SFAPI, HCM Suite, SuccessFactors, HXM, CE, allJobChangesPerDay, allCompensationChangesPerDay, segmentsForEnhancedEffectiveEndDateFilter , KBA , LOD-SF-INT-API , API & Adhoc API Framework , LOD-SF-INT , Integrations , LOD-SF-INT-CE , Compound Employee API , How To