Symptom
- For some records in ORD (Online Report Designer), the Assignment Date value is not populated with any data even though the Item has been completed;
- When running similar reports in LMS, the Assignment Date is populated.
Environment
- SAP SuccessFactors Learning
- SAP SuccessFactors People Analytics
Cause
In ORD, blank Assignment Dates indicate that the items were deleted/removed from the users' Learning Plans in LMS. Due to that, the details are no longer stored in the tables which are referenced by ORD.
Resolution
The reports in both ORD and LMS are working as expected.
ORD does not have access to the LMS PH tables (history tables), which have all the Assignment Date historical details. Due to that, when you run the similar report in LMS, as the LMS report have access to the PH tables, it can generate and report all Assignment Dates (even when the item is no longer on the user's Learning Plan) while ORD cannot.
Keywords
Assignment Dates, ORD, LMS, Analytics, PH tables, PH_STUD_CPNT, PV_STUD_COURSE, PA_STUD_QUAL_CPNT, assignment date , KBA , LOD-SF-LMS-REP , Reporting Data , LOD-SF-ANA-ORD , Online Report Designer , Problem
SAP Knowledge Base Article - Public