Symptom
How to retrieve inactive employees via Integration Center?
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
- Integration Center
Cause
Integration Center uses OData API to retrieve data from SuccessFactors database, the default behavior of OData API is to retrieve active employees only.
Resolution
In order to retrieve the data of inactive users, you need to follow the steps mentioned on page Advanced Filters from the Help Portal, which are:
- On Filter and Sort screen, select "Status" field present under "User" entity with operation parameter as "Is contained in".
- Provide the values "t,f" as shown below ("t" would represent "active", while "f" represent "inactive" status).
- This will make the integration return all possible User records, active and inactive.
Note: If the starting entity of the integration process is not "User", to retrieve all the users with status as "inactive" you can navigate to the "Status" field of "User" and use the above filter.
Note 2: There are more status that can be used, such as "e" or "d". These are used for inactive_external and active_external users.
- To make sure changes are applied on your Integration Center, please see KBA 2430723 - Changes not Applied to Scheduled Integrations in Integration Center
See Also
- 3050510 - [Onboarding] External User Data not visible when viewing reports in Integration Center - Onboarding/Offboarding
- 3290169 - How to find out userid from encrypted data of splunk(server) logs?
- 2786330 - Query on User entity returns blank values - Integration Center
- 2324204 - How to retrieve inactive employees via Integration Center?
- 3375924 - How To check User Status Via Data inspector
- 3319018 - How To Enable Feature Data Inspector
- 2545988 - How To Purge or Delete Users In SuccessFactors
- 3058601 - How To Check Soft Purge or (Hard or Permanent Purge ) User
- 2584658 - How to Check if a User is an EC User using the Integration Center
Keywords
Inactive Status Users for Integration Center, Status is Contained in inactive, active, t, f, inactive, active, terminated, status, Data Inspector , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , LOD-SF-INT-ODATA , OData API Framework , LOD-SF-EC-DRM , Data Retention Management - (DRM & DRTM) EC Data Only , LOD-SF-EC-HRS , HRIS Sync , How To