Results for “course_end_date”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

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:

• OTA_EVENTS (SYNONYM) — the driving table, aliased EVT, holding the core event scheduling attributes such as dates, times, duration, vendor, centre, and event type.
• PO_VENDORS (VIEW) — outer-joined (VEN.VENDOR_ID(+)) to supply the vendor name for events that have an external supplier; events without a vendor simply return NULL for VENDOR_NAME.
• HR_ALL_ORGANIZATION_UNITS (SYNONYM) — aliased BGR, joined on BUSINESS_GROUP_ID to resolve the business group organization name.
• HR_GENERAL (PACKAGE) — invoked for DECODE_LOOKUP calls that translate FREQUENCY, TRAINING_CENTRE, and TRAINING_EVENT_TYPE lookup codes into descriptions, and for GET_BUSINESS_GROUP_ID to restrict rows to the caller's current business group.

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.