SAP Knowledge Base Article - Public

2231540 - Employee data missing in ad-hoc reports

Symptom

  • Few employees are not visible in Employee Central related ad-hoc reports:
    • Job Information (Date Range)
    • Person and Employment Export
    • Person and Employment (As of Date)
    • Person and Employment Audit

Environment

  • SAP SuccessFactors Employee Central - Ad-hoc reports

Reproducing the Issue

  1. Create new employee performing only Basic User Import.
  2. Go to ad hoc reports and create Person and Employment or Job information report.
  3. Generate a report having job information, employment information, etc fields.
  4. Try to locate the newly created user (userid). There will be blank values for this user.

Cause

  • Employee is not properly created in Employee Central or Employee was not properly purged.
  • Employee's job information, personal information, Employment information, Biographical information has not been imported/entered while creation of the user.
  • If reporting on Inactive users. In the Ad Hoc Report People Pill you may need to select "Include Inactive Users" if you have not done so already. This option is not available for all reports. Reports without this option will include inactive as default.

21-05-2017 10-47-50.png

 

  • To Correctly create an employee in Employee Central these imports are the minimum required imports in sequence:
  1. Basic User Import
  2. Biographical/Person Info Import
  3. Employment Details Import

Resolution

  • In case the employee was not properly purged, try to rerun the purge rule. If still facing any issue please raise a support incident for assistance.
  • In case the employee's imports were not done properly, perform the Biographical import and Employment details import again in full purge mode.

See Also

Please refer to Employee Central Imports Admin Guide: Managing Mass Changes in Employee Central

Keywords

Employee Central, Employee data missing in ad hoc reports , KBA , employee central , LOD-SF-EC-REP , Reporting Data (EC core only) , Problem

Product

SAP SuccessFactors Employee Central all versions ; SAP SuccessFactors HXM Core all versions