Status Not Getting Updated In Bulk Enrollment Tables When Class Capacity Is Increased

(Doc ID 1069158.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle Learning Management - Version 11.5.10.0 and later
Information in this document applies to any platform.

Symptoms


Comments
--------

On : 11.5.10.2 version, Enrollment Admin


Find that the Enrollment_Status column  is not getting updated in the Bulk Enrollment tables when the class capacity increases after seeing Waitlisted status for learners.

EXPECTED BEHAVIOR
-----------------------
Expect that the Bulk Enrollment Table to get updated

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create class with capacity 10
2. Populate Bulk Enrollment tables with the required information for 40 learners
3. Run the Bulk Enrollment Process with the request id;
4. Class gets full and Bulk Enrollment table shows that only 10 learners got confirmed due to the class capacity and remaining learners shows as Waitlisted.
5. Go to Learner Administrator and increase the Class capacity to 50
6. Scheduled Process automatically picks all the waitlisted learners and confirm their Enrollment, but it doesn't update the status in the Bulk Enrollment tables.
7. This can be verified using following query.
select p.employee_number, p.full_name, t.name as Booking_Status
from per_all_people_f p, ota_bulk_enr_requests r, ota_bulk_enr_req_members d, ota_booking_status_types t
where r.bulk_enr_request_id = :request_id
and r.bulk_enr_request_id = d.bulk_enr_request_id
and p.person_id = d.person_id
and d.enrollment_status = t.booking_status_type_id
and trunc(sysdate) between p.effective_start_date and p.effective_end_date


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Bulk Enrollment Table is not updated with the new Enrollment Status. So, the Bulk Enrollment was showing Wrong Enrollment Status codes for these learners.

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