Process Bulk Enrollments Completing In Error ORA-20001
(Doc ID 2643944.1)
Last updated on DECEMBER 12, 2022
Applies to:Oracle Learning Management - Version 12.2 HRMS RUP13 and later
Information in this document applies to any platform.
On : 12.2.8 version, Enrollment Admin
Process Bulk Enrollments completing in Error when previously Normal status
Since upgrading from 12.2.6 to 12.2.8 the Process Bulk Enrollments concurrent program completes with Status of Error when previously it completed with Status Normal.
ORA-20001: Course attended in last 6 months or booked in next 6 months | in Package ota_delegate_booking_swi Procedure create_delegate_booking
The issue can be reproduced at will with the following steps:
Customer would bulk enroll 3 learners in a classroom based class(say ClassA) and it was successful.
Later customer would pick the same 3 learners and try to bulk enroll them in another class room based class with similar dates(say ClassB).
This would result in error in their bulk enrollment concurrent program.
Then enroll one of those learners via single enrollment into ClassB.
After receiving the standard Oracle warning message of date overlap, once admin clicks on OK, single enrollment would error with CUSTOM ERROR
message "ORA-20001: 1: Course attended in last 6 months or booked in next 6 months | in Package ota_delegate_booking_swi Procedure create_delegate_booking"
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