2211636 - SuccessFactors OData API: SFOData.EmpWorkPermit does not return all records

SAP Knowledge Base Article - Public

2211636 - SuccessFactors OData API: SFOData.EmpWorkPermit does not return all records

Symptom

  1. The EmpWorkPermit OData entity returns incomplete results. OR It does not return complete data.
  2. It is also observed that varying results are returned when different filters are used along with the query. For eg. "created-on" and "country".

Environment

SuccessFactors BizX System

Reproducing the Issue

  1. Query the SFOData.EmpWorkPermit entity.
  2. This would return incomplete data.

Cause

One of the business keys of the EmpWorkPermit entity are missing and data has not been maintained on UI.

The business key of EmpWorkPermit entity in odata API are:

  1. Country
  2. DocumentNumber
  3. DocumentType
  4. UserID.

Our API framework is designed in such a way that, if any one of business key fields are null (data on the SF end), the related records will be removed from OData API response.

 

In a case, when we have query top=200.

  • 200 records will be returned from database table query.
  • But all the records with any of business key fields being null (Country/DocumentNumber/DocumentType/UserID) will be removed from OData API response and this would result in less than 200 records from being returned in the OData API response.

Resolution

Make sure all four business keys mentioned above are present and are not null.

Keywords

SFOData.EmpWorkPermit, EmpWorkPermit incomplete records, API, OData API , KBA , LOD-SF-INT-EC , EC SF API/OData Entities , Problem

Product

SAP SuccessFactors HCM Core all versions