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 :
- Employment Information
- Scroll down to Employment Detail
Run an AdHoc and ORD Report
Result:
- AdHoc and ORD Report record do not match
- Can report on User A in Adhoc but Cannot report on User A in ORD
- 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 :
- Employment Information
- Scroll down to Employment Detail
Step 2: Export template: EmploymentInfoImportTemplate
- Go to Admin Center -Import Employee Data
- Download template: EmploymentInfoImportTemplate
Step 3: Build your import file base on Step 1: Information
Step 4: Validate Import File Data and Import
Result:
Adhoc report
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