2767376 - Employee Records missing in the API response while your scheduled replications are running using last_modified_on filter - Successfactors HXM Suite

You are noticing that few records are getting missed in the response payload while making  CompoundEmployee API calls or OData calls running your processes using Last Modified On as filter i.e. pick only those records which has been changed since last successful run.

One of the potential root cause would be data was not saved completely to database (DB) while API request was triggered i.e. around the time that you see in your API request for LastModifieOn filter parameter.

This usually occurs when:

• Your HR do mass imports using CSV files (Admin center > Import Employee Data or Import and Export Data)
• Your team uses EC Business rules with PostSave

The standard replications or custom replications triggers API call at the very same time when your team is doing changes via CSV mass import and/or EC Business rules with PostSave which can delay the processing of the records in SF database, the filter of LastModifiedOn of the previous run and the subsequent run would not capture the changed employee record.

We have seen this behavior of records missed in the standard replications and no errors can be seen in the Data Replication Monitor UI, middlewares Boomi/CPI or ERP side (SLG1/SRTUTIL). The employee records are updated successfully in the EC system but this information is not received in the ECP/ERP application.

This also occurs more often if your team decided to run integrations in a shorter period (like 1, 2 or 5 minutes between the runs).

SAP SuccessFactors HXM Suite

• CompoundEmployee API
• OData API
• SFAPI 

Records Missing, Employee Master Data Replication, Organization Assignment, CSV mass massive import, Admin center > Import Employee Data or Import and Export Data, API, SFAPI, CompoundEmployee calls, OData, SuccessFactors HCM Suite, data extraction, skipped employees record, time gap, LastModifiedOn, filter, persons not extracted , KBA , LOD-SF-INT-CE , Compound Employee API , LOD-SF-INT , Integrations , LOD-SF-INT-ODATA , OData API Framework , LOD-EC-GCP-PY , Payroll Integration EC to Employee Central Payroll , LOD-SF-INT-API , API & Adhoc API Framework , LOD-EC-INT-EE , Employee Integration EC to ERP On Premise , Problem