SAP Knowledge Base Article - Public

2808357 - Data not fetched for certain users in Job Information for Certain users for Current Date - Canvas Reports

Symptom

  • In Advanced Reporting, data not fetched for certain users in Job Information for Certain users for Current Date - Canvas / ORD reports.
  • They are visible if the date options are set to Show All
  • You can also see these users in Employee Exports and in the UI

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

Reproducing the Issue

  1. Report Center - Report Canvas - New Advanced Reporting query.
  2. Employment Object and add User Sys ID, First & Last Name, Effective Start & End Date then Emp Job Info T Effective Latest Change field
  3. With Date Options selected as Date Type "Current Date" the user csadmin is not shown in the query result while the user sfadmin is shown.

    1_new.png
  4. If you select the Date Type as Show All , csadmin's data is available is shown as below:

    2_new.png

Cause

Effective Latest Change value is "N" for the affected record.
When "Current Date" option is selected,  the query only includes records where Effective Start Date is less than or equal to today's date, Effective End Date is greater than or equal to today and Effective Latest Change is either 1,Y,y,NULL.

Resolution

  1. If you wish to include such records (Effective Latest Change value is "N") as well, change the date options to Show All or to a custom Date Range
  2. If the data is incorrect, you could just modify that record.
  3. You could use the Check tool to idenitfy records with this issue.
    Admin Center > Check tool > Employee Central Core > Job Information

Keywords

Effective Latest Change, Data, missing, EC, Employee, Central, Record, Advanced, Report, Canvas, Center, Date, options, current , KBA , realms_datamissing , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem

Product

SAP SuccessFactors HCM Suite all versions