SAP Knowledge Base Article - Public

2803205 - Score Summary Report is not pulling data when filtering by Completed Date

Symptom

The Score Summary report is not displaying results when applying a date in the report criteria using the fields Completed Date From and Completed Date To.

Environment

SAP SuccessFactors Learning

Reproducing the Issue

  1. Log into HCM >
  2. Navi agate to Learning Administration > 
  3. At Reports, open the Score Summary report >
  4. Select a user and a content object to pull the score data. The user must have a "For credit" completion status for this content object and item >
  5. After running the report, you can see the record there >
  6. Now run the report with the same filters, but add a date in the Completed Date From and Completed Date To fields that covers the period where the employee received the "Not for credit" status >
  7. After running the report, the score for this "Not for credit" completion is not listed there.

Resolution

As per Engineering Team, this is an expected system behavior.

  • The Score Summary report pulls data from the PA_CBT_STUD_CPNT_MOD table, which stores the communication between content and user.
  • For “Not for credit” Completion Statuses (for example, when a user fails a SCORM exam), this table does not store a completion date. Because the completion date remains null, the report cannot filter those records using the Completed Date From and Completed Date To fields.
  • Therefore, when using Completed Date From and Completed Date To, the report will return data only for “For credit” completions (which have a completion date in PA_CBT_STUD_CPNT_MOD).
  • If you need to report on “Not for credit” completions, avoid using the Completed Date From and Completed Date To filters.

Note: In scenarios where the completion is granted outside of content communication (for example, an admin manually records completion), PA_CBT_STUD_CPNT_MOD may not contain a completion date. In such cases, date-based filters in the Score Summary report will not return those records.

    Keywords

    lms, learning, score summary, report, completion, not for credit, for credit, Completed Date From, Completed Date To, PA_CBT_STUD_CPNT_MOD, missing, data , KBA , LOD-SF-LMS-REP , Reporting Data , Problem

    Product

    SAP SuccessFactors Learning all versions