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:
- Query through postman EmpEmploymentTermination?$select=endDate,jobInfoNav/eventReason,personIdExternal,userId,userNav/status&$expand=jobInfoNav&$filter=(personIdExternal eq '*******')
- In output, event reason and complete job information will be null.
From integration center:
- Go to integration center -> My Integrations -> click on create button.
- Select simple outbound integration.
- Choose starting entity as EmpEmploymentTermination and select jobInfoNav.
- Go to configure fields and add a field jobInfoNav/eventReason and any field from job information navigation.
- 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
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