SAP Knowledge Base Article - Public

3599294 - Slow Response Time for PickListValueV2 upsert using API

Symptom

  • The PickListValueV2 upsert using API operation takes an extended amount of time to complete, leading to interruptions in operations.
  • The issue occurs when attempting to create a PickListValueV2 entity via an API operation.

Environment

SAP SuccessFactors OData API

Reproducing the Issue

  1. Initiate an API operation to create a PickListValueV2 entity.
  2. Observe the extended response time.

Cause

Expected behavior when the picklist being Upserted already contains a large amount of data.

Resolution

Please note:

  1. Picklist should be used for configurations which are often have less updates or preferred to be static list.
  2. Recommendation is that picklist size should not cross 50000 values and should have less than 10 time slices.

If your configuration does not satisfy above conditions, probably then there will be performance issues.

See Also

SF Odata guide - PickListValueV2 

Keywords

PickListValueV2, API, slow response, OData API Framework, operations interrupted, extended time, create entity. , KBA , LOD-SF-INT , Integrations , LOD-SF-INT-ODATA , OData API Framework , Problem

Product

SAP SuccessFactors Platform all versions