Search Results otv_one_time_events




Overview
Explore in AI Chat

Overview

OTV_ONE_TIME_EVENTS is a read-only Oracle E-Business Suite view owned by the APPS schema within the OTA (Oracle Learning Management) product family. It presents a filtered, denormalized list of ad hoc training events — one-time classes or sessions that are scheduled outside of a formal course catalog offering. The view consolidates event scheduling data from OTA_EVENTS with vendor and business group descriptions, resolving several encoded lookup values into their user-facing meanings at query time. In Oracle EBS 12.1.1 and 12.2.2, this view is used primarily for reporting, self-service dashboards, and integrations that need to display upcoming one-time training events without joining multiple base tables manually. The view is documented as VALID in ETRM and is exposed through the APPS synonym OTV_ONE_TIME_EVENTS.

Underlying Base Objects

The view is defined over four documented referenced objects, joined as follows:

The WHERE clause restricts results to EVENT_TYPE = 'AD HOC' and to events whose COURSE_END_DATE is on or after the current system date (TRUNC(SYSDATE) <= EVT.COURSE_END_DATE), effectively filtering out historical events.

Key Columns

The view exposes thirteen columns. The COURSE_START_TIME and COURSE_END_TIME columns carry the scheduled start and end times of the event, which is the attribute most relevant to the search term "course_end_time." Additional columns include:

  • EVENT_TITLE — the descriptive name of the event drawn from EVT.TITLE.
  • COURSE_START_DATE / COURSE_END_DATE — the calendar dates spanning the event.
  • COURSE_START_TIME / COURSE_END_TIME — the session clock times.
  • DURATION / DURATION_UNITS — numeric length and the frequency lookup description of the unit.
  • CENTRE — the decoded training centre description.
  • VENDOR_NAME — supplier name from PO_VENDORS.
  • EVENT_TYPE — the decoded event type, always 'AD HOC' in this view.
  • EVENT_ID, BUSINESS_GROUP_ID, BUSINESS_GROUP_NAME — identifiers and the business group organization name.

Common Use Cases and Queries

Typical usage includes upcoming-event dashboards, LMS self-service listings, and extracts feeding external scheduling systems. A common query to retrieve upcoming one-time events with end times is:

  • SELECT EVENT_TITLE, COURSE_START_DATE, COURSE_END_DATE, COURSE_START_TIME, COURSE_END_TIME FROM APPS.OTV_ONE_TIME_EVENTS WHERE COURSE_END_DATE >= TRUNC(SYSDATE) ORDER BY COURSE_START_DATE, COURSE_START_TIME;
  • Filtering by vendor for external-supplier reporting: SELECT EVENT_TITLE, COURSE_END_TIME, VENDOR_NAME FROM APPS.OTV_ONE_TIME_EVENTS WHERE VENDOR_NAME IS NOT NULL;
  • Business-group-scoped reporting, relying on HR_GENERAL.GET_BUSINESS_GROUP_ID to automatically limit rows to the current session's business group.

Because the view resolves lookups and joins at runtime, it is best suited for read-only reporting; it should not be used for transactional updates against event scheduling data.