My Oracle Support Banner

ELM 9.2: LM_LECR_RECERT_RMNDR Doesn't Trigger To Generate Reminder Emails For Warning Status Learners (Doc ID 2644186.1)

Last updated on NOVEMBER 08, 2021

Applies to:

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


The LM_LECR_RECERT_RMNDR event id PeopleCode is failing to detect the Recertification Warning Date trigger and does not post the notification template details to the notification records for routing to the email server.

The issue can be reproduced at will with the following steps:
1. Login as admin. Navigate to Enterprise Learning > Catalog > Maintain Courses. Create new course, DM, class.
2. Navigate to Enterprise Learning > Catalog > Maintain Programs. Create certification program and include new course in Section 1. Value expiration settings according to following values:
- grace period = 1
- recertification period = 2
- validity period = 2
- expiration warning period = 1
- recertification warning period = 1
3. Navigate to Enterprise Learning > Catalog > Maintain Courses. Create new refresher course, DM, class.
4. Navigate to Enterprise Learning > Catalog > Maintain Programs. Create recertification program and include new refresher course in Section 1. Value Expiration Information same as parent certification.
5.Run full catalog and program index rebuilds.
6. Login as learner.
7. Register for Test Initial Certification Program.
8. Navigate to Self Service > Learning > My Learning
9. Click on Title. Click on View Enrollment Options. Click on Enroll, Submit Enrollment.
10. Launch and complete the class.
11. Login as admin. Navigate to Enterprise Learning > Learner Tasks > Administer Program Rosters. View roster of new program and note learner completed the initial certification program. Note the Expiration Dates generated under the Details link.
12. The next day, login as admin, navigate to Enterprise Learning > Program Status Updates. Select LM_WARN and run process.
13. Verify learner status changed to Warning.
14. Wait two days. Navigate to Enterprise Learning > Notifications > Program Notifications > {add run control} > {click} Run button > {check -checkbox for Re Certification Warning notif LM_RECRT_WRN.
15. Email did not get generated.
16. Examined the SQL and noted the following:
“both SQLs check for WHERE A.LM_PRG_STTS IN ('COMP','WAIV','REIS') but not status ‘WARN’.”
Learners that are placed in a Warning status are not being sent the notification emails.




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.