SAP Knowledge Base Article - Public

2413498 - Hire Date is not the same in Adhoc Report and ORD or ODS

Symptom

 

Missing Employment Detail Or Employment Infos in Adhoc report or ORD and ODS
Cannot see Employment and Personal  information
Cannot report on Employment Detail Or Employment Infos in Adhoc report or ORD and ODS
Hire Date is not the same  in Adhoc Report  and ORD or ODS

Environment

Employe Central

Reproducing the Issue

 

Run an Adhoc Report and ORD or ODS report

Result: Hire Date is not the same  in Adhoc Report  and ORD or ODS

 

Cause

 

The data is already present in EP and EC tables, but looks like employment data was not imported for these users.

Resolution

Step 1: Download the import template for the data that will be replaced: 

 In Admin Center > Import Employee Data
 Click ‘Download a blank CSV template’ dropdown and select the appropriate template
 Here: Employment Detail

1detail.png

Step 2: In AdHoc Reporting, run sub domain: Person and Employment Export

In AdHoc Reporting, select Create New Report
Choose the ‘Person and Employment Export’ report definition type
In Column, Select only column “Employee Info”
Build the report based on the import template you downloaded in step 1.
Filter Test user
Save
Keep an unaltered copy of this report as backup

3detail.png

 

Step 3:Review the populated import template to ensure all data is correct


Populate the downloaded import template with the data from your Ad Hoc report. If the fields in the Ad Hoc report and import template match, copy and paste can speed up this portion of the process
Run a Full purge import for the user
In Admin Center > Import Employee Data, for example,
Select Employment Detail
Choose the file created in step 3 and select ‘Validate’ to confirm the information is correct
Once validation is completed with no errors, Import the file

4detail.png

 

Result: Once the "Employment Details" import is performed for these users, ODS  or ORD will include their employee data in the report.

Keywords

   ECT-45904 Hire Date Employment Detail  Employment Infos Adhoc Report ORD ODS     , KBA , LOD-SF-EC-EMP , Employment Information , LOD-SF-EC , Employee Central , LOD-SF-EC-REP , Reporting Data , LOD-SF-EC-ROD , Reporting/Analytics (ODS) , Problem

Product

SAP SuccessFactors HCM Core 1611 ; SAP SuccessFactors HCM Suite all versions