SAP Knowledge Base Article - Public

3339090 - API EmpEmploymentTermination unable (blank value) to fetch job information and event reason of termination event "No-show"

Symptom

You're trying to fetch termination event reason and job information for "No-show" termination event using odata api but output is blank/null.

You are navigating from EmpEmploymentTermination to job information for event reason according to this KBA: 2536019 - SFOdata.EmpEmploymentTermination API's event reason field is not selectable

But for all the users, event reason and job information records coming as null.

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

Environment

  • SAP SuccessFactors HXM Suite
    • ODATA API 

Reproducing the Issue

Using OData api through Postman:

  1. Query through postman EmpEmploymentTermination?$select=endDate,jobInfoNav/eventReason,personIdExternal,userId,userNav/status&$expand=jobInfoNav&$filter=(personIdExternal eq '*******')
  2. In output, event reason and complete job information will be null.

From integration center:

  1. Go to integration center -> My Integrations -> click on create button.
  2. Select simple outbound integration.
  3. Choose starting entity as EmpEmploymentTermination and select jobInfoNav.
  4. Go to configure fields and add a field jobInfoNav/eventReason and any field from job information navigation.
  5. Output of event reason and job information field will be null.

Cause

EmpEmploymentTermination API will not expand EmpJob for No-Show cases. 

Resolution

If you want to fetch No-show records, then query should have EmpJobs with $filter startDate eq EmpEmploymentTermination's endDate and userId eq EmpEmploymentTermination's userId. 

Starting Entity - EmpJob

See Also

2536019 - SFOdata.EmpEmploymentTermination API's event reason field is not selectable  

Reporting No-Show New Hires or Rehires | SAP Help Portal 

Keywords

No-show event, EmpEmploymentTermination, event reason, blank, null, job informagion, employment termination record, odata, integration center, API, unable to fetch, SF , KBA , LOD-SF-INT-ODATA , OData API Framework , Problem

Product

SAP SuccessFactors HXM Suite 2305