Search Results otv_scheduled_events




Overview
Explore in AI Chat

Overview

OTV_SCHEDULED_EVENTS is an APPS-owned database view in Oracle E-Business Suite Release 12.1.1 and 12.2.2, delivered under the OTA (Oracle Training Administration / Learning Management) product family. The view presents a consolidated, decoded listing of scheduled training events — that is, events whose EVENT_TYPE is 'SCHEDULED' — together with the offering version, venue, pricing, enrolment window, and delivery information required to publish or administer them. Its purpose is to expose the same information that Oracle iLearning and the Learning Management administrative pages display, but in a single flat relational shape suited to reporting, extracts, and integration.

Unlike the underlying transactional tables, which store coded lookups and surrogate identifiers, OTV_SCHEDULED_EVENTS resolves lookup codes into their translated meanings through HR_GENERAL.DECODE_LOOKUP, and derives availability through OTA_VIEWS_PKG.OTA_GET_PLACES_AVAILABLE. It applies business filters at definition time (only SCHEDULED events, only currently open or forthcoming enrolments, only active/planned/full statuses), so a query against the view returns only the events relevant to an active catalogue rather than the complete historical event population.

Underlying Base Objects

The documented base objects referenced by the view are:

The join is anchored on ACTIVITY_VERSION_ID, with TRUNC(SYSDATE) constrained to fall inside the enrolment window and on or before the course end date, and EVENT_STATUS restricted to 'N', 'P' and 'F'.

Key Columns

Common Use Cases and Queries

Typical uses include building a public course catalogue, feeding an external LMS or web front end, auditing enrolment windows that are about to close, and monitoring seats remaining per event.

  • Upcoming catalogue extract: SELECT title, course_start_date, centre, standard_price FROM otv_scheduled_events ORDER BY course_start_date;
  • Capacity monitoring: SELECT event_id, title, maximum_attenees, "PLACES_AVAILABLE" FROM otv_scheduled_events WHERE event_status = 'Planned'; (reference the places-available column by its position or alias, since it is an expression.)
  • Vendor-delivered events: SELECT title, vendor_name, enrolment_end_date FROM otv_scheduled_events WHERE vendor_name IS NOT NULL;
  • Business-group reporting: SELECT business_group_id, COUNT(*) FROM otv_scheduled_events GROUP BY business_group_id;

Because the view embeds SYSDATE-based predicates and package calls, performance depends on the OTA_EVENTS indexes and on the efficiency of OTA_VIEWS_PKG; for high-volume extracts, restricting by BUSINESS_GROUP_ID or date range is advisable.