3421751 - Slow performance when trying to upsert EmpJobRelationships via Integration Center.

Slow performance when trying to upsert EmpJobRelationships via Integration Center.

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

SAP SuccessFactors HXM Suite

• Integration Center

1. Approximately 10,000 EmpJobRelationships need to be uploaded.
2. Integration Center takes more than 10 hours to complete the task.

The Integration Center uploads 1,000 data pieces per page, and for each page, it calls SF's internal service layer to load the relevant history for these users. This results in data bloat and increases the processing time of the Integration Center.

We recommend reducing the Source Page size to 50, which will significantly reduce the processing time.

Please note that this issue is specific to Integration Center jobs. When running the same data through an SF UI EC import job, it only takes 37 minutes. This is because EC Import inserts these records internally in batches of 50/100, making each transaction lighter and faster.

EC Odata API, more than 10 hours, too slow, Job run time, Soure page size, 1000, 50 , KBA , LOD-SF-INT-INC-JOB , Integration Center Job , Problem