Search Results auto_enroll_from_waitlist

Overview

OTA_TDB_WAITLIST_API is an Oracle EBS Applications (APPS) public API belonging to the Oracle Training Administration (OTA) product family — specifically the Training Delivery and Booking (TDB) subsystem used by Oracle Learning Management (OLM). The package governs automated waitlist processing, enabling the system to promote learners from waiting lists into confirmed enrollments when capacity becomes available in a training event. The package is defined with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking session and resolves objects through APPS synonyms, which is standard for OLM public APIs.

The API addresses a recurring business requirement in learning administration: when an enrollment is cancelled, a seat is added, or a class is rescheduled, candidates waiting on a waitlist should be offered or granted enrollment based on configurable priority rules. OTA_TDB_WAITLIST_API encapsulates that promotion logic so it can be reused consistently across forms, concurrent processes, and custom extensions rather than reimplemented against the underlying booking tables.

The package header carries the RCS identifier $Header: ottdb03t.pkh 120.0 2005/05/29 07:38:38 appldev noship $, indicating a long-stable interface that has persisted largely unchanged into the EBS 12.1.1 and 12.2.2 code lines. Its release status ("noship") reflects the standard header comment convention rather than an unsupported interface — it is documented as an API in ETRM.

Key Procedures and Functions

The documented interface exposes a single public procedure:

• AUTO_ENROLL_FROM_WAITLIST — Drives automatic enrollment of waitlisted delegates into a training event. It accepts a validation flag and an optional business group and event context, allowing the caller either to perform a real promotion or to run in validate/simulation mode before committing. When no specific event is supplied, the procedure may evaluate waitlists more broadly within the given business group. This procedure is the sole entry point of the package and the object users typically reference when searching for "auto_enroll_from_waitlist."

No additional functions or procedures are documented in the package specification. The parameter list shown in the header (a boolean validation flag plus business group and event identifiers) should be confirmed against the deployed specification at patch level, since parameter defaults and optionality can vary between 12.1.1 and 12.2.2 instances.

Tables Accessed

The package operates against the following documented tables through APPS synonyms:

• OTA_DELEGATE_BOOKINGS — The core booking/enrollment records for delegates. The procedure reads waitlisted bookings and updates their status upon promotion.
• OTA_BOOKING_STATUS_TYPES — Defines valid booking statuses (for example, waitlisted, confirmed, cancelled). The procedure uses these to identify candidates eligible for promotion and to set the resulting status.
• OTA_FINANCE_LINES — Financial lines associated with bookings. Promotion may generate or adjust finance lines so that charges follow the delegate into a confirmed enrollment.
• PLITBLM — A generic PL/SQL table (index-by table) used internally for set-based processing and temporary in-memory collections; it is not a business data table.

Usage Notes

AUTO_ENROLL_FROM_WAITLIST is typically invoked when enrollment capacity changes, such as after a cancellation frees a seat or when an administrator adjusts event capacity. It is called from OLM booking and waitlist forms, from concurrent programs that process waitlists in batch, and from custom code that must honor the same promotion rules as the standard product. The package is referenced by one other package, indicating it is a shared building block within the OTA booking layer.

Callers should invoke the procedure within a well-defined transaction, use the validation flag to preview changes where supported, and ensure the business group context is set correctly so that security and multi-org filtering behave as expected. Because the interface is public and stable, it is the preferred supported mechanism for automating waitlist promotion rather than direct DML against OTA_DELEGATE_BOOKINGS.