SAP Knowledge Base Article - Public

2995641 - empCompensationCalculatedNav field is causing slow performance - OData API

Symptom

You are doing OData API queries in empCompensationCalculatedNav and they are facing slow performance (bad response times).

Environment

  • SAP SuccessFactors HCM Suite
    • OData API
    • Integration Center

Cause

The fields from empCompensationCalculatedNav are transient, meaning that they are not stored in the database and are calculated at the time the API call is performed. This is an expected behavior which causes the slow response time.

Resolution

This object has been designed for UI consumption and single-user queries scenarios only, so it's not really suitable for mass data replication, even in small batches.

You can try the following workarounds to resolve the performance issue:

  • If you are doing a mass replication with this field selected, you will need to tune the page size so that the API can process the records. You can start by reducing the page size to 200 and see if the issue is resolved. If not, you might have to further reduce the page size and check.
  • If reducing the page size is not possible or is not helping, you must then create 2 custom fields (one for range penetration and one for compa ratio) in the Compensation Info object in EC, and create an onSave rule associated to the Compensation Info object which calculates and updates the value of these 2 custom fields every time a Compensation record is saved.

Please note that this issue may also occur in Integration Center, resulting in errors related to timeouts or thread issues when the Integration Center job is executed. If you have multiple integrations which try to update the EmpCompensation entity, then it would be good to avoid scheduling them at the same time.

See Also

EmpCompensationCalculated

Performance: How to improve it

Keywords

EmpCompensationCalculated, empCompensationCalculatedNav, compaRatio, compa ratio, slow, bad, timeout, time out, 504, performance, EmpCompensation, OData API , KBA , LOD-SF-INT-EC , Employee Central SFAPI & OData Entities , LOD-SF-INT-INC-ODATA , ODATA API In Integration Center , Problem

Product

SAP SuccessFactors HCM Suite all versions