Search Results event_end_date




Overview
Explore in AI Chat

Overview

OTFV_ONE_TIME_TRAINING_EVENTS is an APPS-owned business view template in Oracle E-Business Suite (documented for 12.1.1 and 12.2.2) within the OTA – Learning Management product. As the description states, it is a "business view template from which the flexfield view is generated" — meaning Oracle Training Administration (OTA) uses it as the source definition to build a runtime flexfield-enabled view that exposes one-time training event data through the Flexfields (Descriptive Flexfields) framework. It is a read-only view (defined WITH READ ONLY) that consolidates information about ad hoc, one-time training events and presents it with user-friendly display names.

The view is significant because it transforms technical key columns (IDs) into descriptive business names (event name, business group name, training centre, supplier), making it a natural foundation for reporting, extracts, and integration of training event data. It filters to ad hoc events only (EVT.EVENT_TYPE = 'AD HOC'), so it covers one-time delivery rather than scheduled recurring offerings. The "_DF" pseudo-column ties the view into the descriptive flexfield mechanism, and the language-aware joins ensure multilingual TL data is returned for the caller's session language.

Underlying Base Objects

Per the documented ETRM metadata for 12.2.2, the view is defined over the following referenced base objects:

The joins are constructed as outer joins (VEN.VENDOR_ID(+) and ORGT1.ORGANIZATION_ID(+)), allowing events without a supplier or training centre to still be returned. Language predicates on BGRT and ORGT1 restrict the TL rows to USERENV('LANG').

Key Columns

The view exposes the following documented columns:

Common Use Cases and Queries

Typical uses include training event listings, calendar and scheduling extracts, completion/attendance reporting, and integration feeds into external learning or HR systems. Because EVENT_END_DATE is derived from COURSE_END_DATE, a common query is to retrieve events finishing within a date window:

SELECT business_group_name,
       event_name,
       event_start_date,
       event_end_date,
       training_centre,
       supplier_name
FROM   apps.otfv_one_time_training_events
WHERE  event_end_date BETWEEN :p_from_date AND :p_to_date
ORDER  BY event_end_date;

A second common pattern is to count ad hoc events per training centre over a period:

SELECT training_centre,
       COUNT(*) AS event_count
FROM   apps.otfv_one_time_training_events
WHERE  event_end_date >= :p_period_start
GROUP  BY training_centre;

The view is read-only and already filters to 'AD HOC' events and the caller's business group and session language, so reports should not apply additional business group or event type predicates unless overriding those defaults intentionally. Where translated data is required in multiple languages, callers must ensure the session language (USERENV('LANG')) matches the desired TL rows.