SAP Knowledge Base Article - Public

2363806 - Missing Users in Adhoc or Advance Reporting ( ODS or ORD) Reports - Employee Central

Symptom

  • Users have Employment information and Personal Information update but they are missing in AdHoc and ORD Report
  • We cannot report on some users in Adhoc and ORD Report
  • User in Adhoc and ORD Report do not match
  • Not all employees are present in ODS

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

Environment

  • Employee Central - Employment Information
  • Employee Central - Adhoc Report

Reproducing the Issue

Go to test user UI :

  1. Employment Information
  2. Scroll down to Employment Detail

1detail.png

Run an AdHoc and ORD Report

Result:

  1. AdHoc and ORD Report record do not match
  2. Can report on User A in Adhoc but Cannot  report on User A in ORD
  3. Cannot report on User A in Adhoc

Cause

The data is already present in EP and EC tables. But looks like employment data was not imported for these users.
For a user to be an EC user, You must  import of employmentInfo or Employment Detail record
Once the "Employment Details" import is performed for All missing users, ODS will include their employee data in the report.

Resolution

Import Missing User Employment Details Record

Step 1: select user

Go to test user UI :

  1. Employment Information
  2. Scroll down to Employment Detail

1detail.png

Step 2: Export template: EmploymentInfoImportTemplate

  1. Go to Admin Center -Import Employee Data
  2. Download template: EmploymentInfoImportTemplate

2detail.png

Step 3: Build your import file base on Step 1: Information

3detail.png

Step 4: Validate Import File Data and Import

4detail.png

Result:

Adhoc report

6detail.png

See Also

2092931 - Employee Central: Some users do not Synchronize via HRIS Sync and do not appear in Ad Hoc and ORD Reports (IS_EC_SYSTEM_OF_RECORD)

Keywords

User in AdHoc and ORD Report do not match, Not all employees are present in ODS, Employment Details, AdHoc report, ODS, ORD,Advance reporting, ECT-45904 , KBA , LOD-SF-EC-REP , Reporting Data (EC core only) , LOD-SF-EC , Employee Central , LOD-SF-EC-EMP , Employment Information (Employment Details) , Problem

Product

SAP SuccessFactors Employee Central all versions