3433095 - Item Completion record for a user is missing in the Online Item status report however the completion is present in the Learning history report

User have been assigned an Item and Completed the Item. However the completion record is not showing in Online Item status report but is showing in the Learning history report and this issue happens only for few users.

For Other users, Completion is being shown in both Online Item status and Learning history report

SAP SuccessFactors Learning 

1. Create an Item and Assign an Item to the user either directly or via system AP

2. User completes the Item

3. Delete the Completed Item from the user 

• Either by going to Items > Assigned Items tab > Select the filter > Include Completed Items > Search for the Completed Item > Click on 3 dots > Remove it 
• Or Remove the user or Item from Assignment profile If the Item is assigned via Assignment profile

4. Run the Online Item status report for the user and Item, you could not find any record of completion for this Item for the user

5. Run the Learning history (CSV) report, you will find the completion record for this Item

After Completion, the Item was removed from user hence there is no current association. Online Item status report only fetches those Items which were currently assigned/completed by users and which were not deleted from the user either before/after completion of the Item.

Whereas, Learning history report fetches all the Completion history for the Item even when the Item is deleted from the user post completion

When the Item is removed from the user before/after completion, then this Item details will no longer be pulled by Online Item status report.

Online Item status report query is designed to fetch the results PA database tables which only have current associations. If the Item is deleted from the user, then this item is no longer associated to user and will not be present in PA table hence no record for this will be fetched in the Online Item status report.

To know if the Item is deleted from the user, you can run the learning plan audit report for the user. If you see a Delete action being performed after the completion and there are no further insertions of the item, then this means that Item is deleted from the user and there is no current association.

However, learning history report queries on a table called PA_CPNT_EVTHST which stores item history details therefore learning history report fetches the completion record even if the Item is deleted from user post Completion

Hence, This is working as per expected.

Online Item status report, Learning history report, Item completion, discrepancy, missing record , KBA , LOD-SF-LMS-REP , Reporting Data , How To