OBIA 7.9.6.x: PeopleSoft Learning Management Scores Not Showing As Expected (Doc ID 2107539.1)

Last updated on JUNE 01, 2017

Applies to:

Business Intelligence Applications Consumer - Version 7.9.2 [AA 1615] to 7.9.6.4 [Release V7]
Information in this document applies to any platform.

Goal

When loading learning management enrollment scores from Peoplesoft (PSFT) and referring to PS_LM_ENRLMNT table column LM_SCORE to load the score details into the data warehouse. This is a delivered functionality of OBIA. For some courses the scores are recorded in PS_LM_TRACK_STUDNT table, the LM_SCORE_RAW column in PSFT. This is a delivered functionality from PeopleSoft. 

We want to know if there is any issue as to why the PS_LM_TRACK_STUDNT score is not getting updated in PS_LM_ENRLMNT table as the scores should get updated in the PS_LM_ENRLMNT table being the main table to hold all enrollments.

In Peoplesoft ELM, the Learner's Score is not always getting captured in PS_LM_ENRLMT. Why this is happening and how does the Score gets stored in ELM 9.2?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms