ELM 9.2: Selecting Class Code Link From Find Learning In ELM Self-service Causing Spike On Database Server

(Doc ID 2071107.1)

Last updated on NOVEMBER 30, 2015

Applies to:

PeopleSoft Enterprise ELM Enterprise Learning Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms


Selecting class code link from find learning in ELM self-service causing spike on database server  

We recently upgraded to ELM 9.2 and have noticed that when an ELM user selects the class code link from the find learning page in employee self-service it is using a lot of CPU and causing a spike on our database server for the sql statement below. It is retrieving all 4,853,309 rows on this view.

SELECT LM_PERSON_ID, LM_ENRLMT_ID, LM_CI_ID, LM_ACT_ID, LM_ACT_REQ, LM_TYPE, LM_STTS, LM_ACT_FEE, TO_CHAR(LM_COMPL_DT,'YYYY-MM-DD'), LM_GRADE_VAL_ID, LM_SCORE, LM_REQUESTOR_ID, LM_EMPL_RCD FROM PS_LM_SS_ACT_VW ORDER BY LM_PERSON_ID, LM_ENRLMT_ID

Component name is LM_LEARNING_ITEMS
Page name is LM_LEARN_ACT_DTL

 
Steps to Replicate Issue:
1. Log in as Learner
2. Navigate to Main Menu > Self Service > Learning> Find Learning
3. When results return, click on Class Code in the results and talks a long time to access the page.


 

Cause

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