ELM 9.2: Program Historical Credit Evaluates Oldest Class Completion When Multiple Completions Exist

(Doc ID 2166726.1)

Last updated on JULY 29, 2016

Applies to:

PeopleSoft Enterprise ELM Enterprise Learning Management - Version 9.2 and later
Information in this document applies to any platform.


On : 9.2 version, Administrator-Learner Tasks

Statement Of Issue

Program Historical Credit Evaluates Oldest Class Completion When Multiple Completions Exist

A learner registers for a certification and completes the course attached to it leads to learner get certified. Administrator updates the learner’s certification status to warning. On the next day (since we have historical credit is turned off on the recertification course), learner registers for recertification and then learner enrolls for the same course. Even though the learner has not launched/completed the course (immediately upon enrollment), the certification gets marked as complete.

Replication Steps:

1. Create a program with a single section. Assign a course to that section. Check the Historical Credit check box and enter a value in the days field that is greater than the oldest completion date of a class associated to the learner. Using the example of John Doe, you could enter ‘180’ days, which would go far enough in the past to encompass both completion dates.

2. Supply all the other required values for the program and save the program. Set the Section Completion Rule to require completion of the one section you added. Rebuild the program index.

3. Administratively register the learner into the newly created program. You should see the learner status automatically go to Completed for the program. This is due to historical credit.

4. Open sqlplus or SQL Developer and query the LM_PRG_ITEM_ENR table where the LM_PRG_REG_ID = the confirmation ID of the program registration you just performed. Obtain the value of LM_ENRLMT_ID and LM_OBJ_ID.

5. Query the LM_ENRLMT table using the LM_PERSON_ID of the learner you registered in the program and the value of LM_OBJ_ID from step 4 (as LM_CI_ID). You should see at minimum two rows representing the multiple class completions. Take note of the LM_COMPL_DT value. The value of LM_ENRLMT_ID obtained in step 4 will match the older of the two completed classes. This means when the learner was registered into the program, historical credit used the oldest completed class for historical credit, instead of the newest completed class.


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