2147991 - Required date is one day off in Learning standard reports

When running "User Learning Plan Audit Report (CSV)" report, required Date for some users is one day earlier or later than required date seen in UI

SAP SuccessFactors Learning

1. Login and go to Learning Administration
2. Go to Preferences of the admin account.
3. Change Active Locale ID to Japanese and Time zone to Japan Standard Time.
4. Select any user and go to Assigned Items tab.
5. Set Required Date of one assigned item to one date.
6. Go to Reports and run User Learning Plan Audit Report (CSV) report on this user.
7. Open downloaded CSV file and found that Required Date is wrong (date set in step 5 plus 1 day).

This is by design if the user has a different time zone from the admin. 

Required date of an assigned item is stored in the time zone of the user(not Admin). 

For example: user A in EST and user B in JST. 

If an admin sets a required of 2/10/2015 for the two users, the stored date in the system for each user would be one day different according to the time zone of each user.

The display value of the required date in Admin UI is controlled by the "learningPlanDisplayInLearnerTimezone" configuration in LMS_ADMIN.
Assume that the admin is in JST, the user is in EST and the stored required date is 2/10/2015 EST.

• If learningPlanDisplayInLearnerTimezone is set to true (default value), then Admin UI will display 2/10/2015(EST time).
• If learningPlanDisplayInLearnerTimezone is set to false, Admin UI will display 2/11/2015(JST time).

To show required date in Admin time zone (JST), it is necessary to update the learningPlanDisplayInLearnerTimezone configuration to false.

To do this navigate to System Admin > Configuration > System Configuration > LMS_ADMIN

Note: User Learning Plan Audit Report or any other admin report with required date will only display require date in the user time zone.

earning plan, required date, report, User Learning Plan Audit Report, japanese, locale, learningPlanDisplayInLearnerTimezone , KBA , LOD-SF-LMS-REP , Reporting Data , Problem