SAP Knowledge Base Article - Public

2786330 - Query on User entity returns blank values - Integration Center

Symptom

You have made a query in Integration Center navigating to the User entity and some fields from it returned with blank values.

Example:
You start a query in the EmployeeTime entity and navigates to the User entity.

Some of the records related to the User entity appear as an empty value:

user_blank_1.jpg


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
  • SAP SuccessFactors Employee Central
  • Integration Center

Reproducing the Issue

  1. Create a new Integration Center job
  2. Add a field that navigates to User entity
  3. Some of its fields returned with blank values

Cause

When a record from the User entity belongs to an inactive user, its data cannot be fetched through navigations unless you set up a specific filter.

Resolution

Add the filter to fetch inactive users:

  • 2324204 - How to retrieve inactive employees via Integration Center?
    - The values should return properly after this.

  • 3375924 - How To check User Status Via Data inspector

See Also

  • 3319018 - How To Enable Feature Data Inspector
  • 3375924 - How To check User Status Via Data inspector
  • 3058601 - How To Check Soft Purge or (Hard or Permanent Purge ) User
  • 2545988 - How To Purge or Delete Users In SuccessFactors
  • 2584658 - How to Check if a User is an EC User using the Integration Center - isECRecord Boolean
  • 2922739 - How to purge integrated external learners using DRM - SAP SuccessFactors Learning
  • 3038172 - [Onboarding] DRTM Onboarding Purge
  • 2584658 - How to Check if a User is an EC User using the Integration Center
  • 2922739 - How to purge integrated external learners using DRM - SAP SuccessFactors Learning
  • 3038172 - [Onboarding] DRTM Onboarding Purge
  • 0003050510 External User Data not visible when viewing reports in Integration Center - Onboarding/Offboarding
  • 0003052056 - How to delete or permanent purge an inactive onboardee user - Onboarding
  • 2618848 - Enabling Change Audit Feature
  • 2790859 - Change Audit Log Report for Metadata Framework (MDF) Configuration and Data Changes.

Keywords

blank, empty, null, values, user, entity, integration center, successfactors, success, factors, navigation, export, userID, first name, last name, firstname, lastname, employeetime, employee, time , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , LOD-SF-EC-EMP , Employment Information (Employment Details) , Problem

Product

SAP SuccessFactors HCM Suite all versions