SAP Knowledge Base Article - Public

3204452 - ORD Report 'Learning Item assignment and history' does not display Assignment Date for Users - But Data exists in the Database

Symptom

  • When customer runs a ORD Report 'Learning Item assignment and history' the column for Assignment Date has no data for some users.
  • Data is appearing in the Assignment Date for these Users in the Database.

Environment

SAP SuccessFactors Learning

Reproducing the Issue

  1. Login to the instance
  2. Navigate to Reporting
  3. Run the ORD report
  4. Notice 'Assignment Date' blank for some users

Cause

 This is not an issue, the report will take the assignment date from the PA_STUD_CPNT table.

1) When item is completed without assigning to user then there is no entry inserted in pa_stud_cpnt. In this case report will not show the assignment date.

2) When item is assigned to user, entry will be created in table pa_stud_cpnt. When item is completed by any means, this entry in table pa_stud_cpnt  will be retained which helps to show the association between item and user.

3) It may have been observed in the customer data for users who did not have an assignment date, the entry was removed from pa_stud_cpnt because an assignment profile removed the assignment. This can be verified by running a learning plan audit report for some of the users who do not show an assignment date.

Resolution

This is expected behaviour of the ORD report.

Another option is to use SAC - People Analytics Reporting Stories (PARS).

Please familiarise with SAC - People Analytics Reporting Stories (PARS)

Please see the following link for further information Release Schedule for Learning Data in Stories in People Analytics

See Also

https://community.successfactors.com/t5/Reporting-Analytics-and/Release-Schedule-for-Learning-Data-in-Stories-in-People/bc-p/275421#M1661

Keywords

ORD,report,assignment,date,blank,profile,Learning,Item,history , KBA , LOD-SF-LMS-REP , Reporting Data , LOD-SF-LMS , Learning Management System , Problem

Product

SAP SuccessFactors HXM Core 2111