SAP Knowledge Base Article - Public

2807782 - User Item History Audit Report - Time stamp of columns not aligning with Last Updated Time

Symptom

Upon running the User Item History Audit Report (CSV), when comparing other columns such as Completion Date to the Last Update Time column are not the same. Comparing the Completion Date with other reports or with the user interface, the data is not the same.

Environment

SAP SuccessFactors Learning Management Solution (LMS)

Reproducing the Issue

  1. Complete an item as a user
  2. The completion time stamp of the user is January 1st 2019 at 4:00 PM Central Standard Time
  3. Run the User Item History Audit Report (CSV) with the user ID as the filter
  4. Notice in the report the Completion Date for the item is January 1st 2019 at 10:00 PM
  5. Notice that the Last Update Time column is January 1st 2019 at 4:00 PM Central Standard Time

Cause

All data in the database is in Universal Standard Time (UTC) and the User Item History Audit Report is only converting the Last Update Time to the admin preference which is what is seen on the user interface as well. All other columns are not converted.

Resolution

Currently only timezone conversion on the Last Update Time column is expected behavior and no other column is being converted to the admin's timezone preference.

If you wish to change this behavior, please create an enhancement request. The process for this can be seen here 2090228

Keywords

User item history audit report csv timezone data not correct align different utc aligned change compare successfactors lms learning LRN-60366 , KBA , LOD-SF-LMS-REP , Reporting Data , Problem

Product

SAP SuccessFactors Learning all versions