SAP Knowledge Base Article - Public

2819118 - Integration Center returning blank value for field "manager"

Symptom

I have an integration center job where the field "manager" is returning blank / null value when the manager is inactive.

How to retrieve / populate this field?

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
    • OData API

Reproducing the Issue

Scenario:

Sample user mfullington's manager is jgeorge.

User jgeorge is an inactive user in Bizx.

  1. Create Integration Center job Type: CSV file Output Integration
  2. Starting entity: User
  3. In the result, you will see that the field "Manager User ID" is blank for sample user "mfullington"

blankManager.jpg

Cause

Odata API only returns active user by default. This is in case status is not specified on the filter.

Resolution

  1. In Integration Center's Filter and sort
  2. On the Advance Filter > click on Browse
  3. On Entity Tree View > Search Manager > Status

    filter.jpg

  4. In Operation choose "is contained in" and provide values "t,f"

    statusFilter.jpg

  5. Go to Configure Fields, and you will see that the inactive manager of mfullington has now been properly returned

    managerReturned.jpg

See Also

2324204 - How to retrieve inactive employees via integration center

2742107 - Integration Center: Frequently asked questions

Keywords

Inactive manager null value, integration center, inactive, t, f, active, contained in, terminated, filter, blank, empty, null, not returning, fetching, ic, integration center, issue, , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , Problem

Product

SAP SuccessFactors HCM suite all versions