ELM 9.2: LM_LC_ID Incremented Twice When Adding a New Session Learning Component (Doc ID 2082410.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


 LM_LC_ID incremented twice when adding a new session learning component to a class.

 
Steps to Replicate Issue:
 
1) Log in as an Administrator
2) Navigate to Main Menu > Enterprise Learning > Catalog > Maintain Classes and {search/select Class with delivery Method Class
3) From the Learning Component Tab, add a new Learning component  for Session.
4) Enter Session information on page and click Ok on Learning Component page.
5) Then, click Save on the Classes page.
6) Run the following SQL statements to review data added to table:
a. select *  from PS_LM_ACT WHERE LM_ACT_CD= {enter class code for Class}
b. select * from PS_LM_LC  WHERE LM_ACT_ID = {LM_ACT_ID from the result of a.}
7) Notice the LM_LC_ID value.
8) Then, return to ELM and Enter a 2nd Session information on page and click Ok on Learning Component page.
9) Then, click Save on the Classes page.
10) Run the following SQL statements to review data added to table:
a. select *  from PS_LM_ACT WHERE LM_ACT_CD= {enter class code for Class}
b. select * from PS_LM_LC  WHERE LM_ACT_ID = {LM_ACT_ID from the result of a.}
11) Notice that the new LM_LC_ID is incremented by 2.

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