Search Results session_end_time

Overview

OTFV_TRAINING_EVENT_SESSIONS is an APPS-owned database view in the Oracle E-Business Suite Learning Management module (OTA). It is documented as a business view template from which a flexfield view is generated, meaning it forms part of the descriptive flexfield (DFF) infrastructure used by Oracle Training Administration rather than serving as an end-user reporting object in isolation. The view presents session-level scheduling information for training events, joined to the parent scheduled event, the underlying activity definition and version, the training centre organization, and the business group. In Oracle EBS 12.1.1 and 12.2.2 the object exists in the APPS schema with a synonym exposed to other schemas, and it is registered as VALID.

The view is primarily used by the flexfield view generation process for the OTA_EVENTS entity, as indicated by the literal column value '_DF:OTA:OTA_EVENTS:EVT'. This context identifier ties the view to the OTA_EVENTS descriptive flexfield, allowing session records to surface the appropriate DFF segments through a generated view. The view is created WITH READ ONLY, so it is strictly a query object.

Underlying Base Objects

The documented base objects referenced by the view are:

• OTA_EVENTS (synonym) — used twice, aliased EVT for the session row and EVT2 for the parent scheduled event.
• OTA_ACTIVITY_DEFINITIONS and OTA_ACTIVITY_VERSIONS — supply the activity name and version.
• HR_ALL_ORGANIZATION_UNITS and HR_ALL_ORGANIZATION_UNITS_TL — provide the business group name and the training centre name.
• OTA_OFFERINGS — referenced for the offering relationship via OFFERING_ID.
• OTA_GENERAL (package) — provides the business group security function OTA_GENERAL.GET_BUSINESS_GROUP_ID.
• OTA_ACTIVITY_DEFINITIONS_TL and OTA_ACTIVITY_VERSIONS_TL are also listed among the referenced base objects for translated names.

The join logic restricts sessions by EVT.EVENT_TYPE = 'SESSION' and requires the parent row to be EVT2.EVENT_TYPE = 'SCHEDULED', linking the two through PARENT_EVENT_ID = EVT2.EVENT_ID. Outer joins ((+)) are applied to the training centre, activity version, and activity definition so that sessions are not dropped when these relationships are absent. Language joins on the _TL tables use USERENV('LANG') to return names in the current session language, and business group filtering is applied through the security function.

Key Columns

• SESSION_NAME — the title of the session event (EVT.TITLE); this is the column most commonly searched on.
• SESSION_DATE, SESSION_START_TIME, SESSION_END_TIME — the session's course start date, start time, and end time.
• EVENT_NAME, EVENT_START_DATE, EVENT_START_TIME, TIME_ZONE — attributes of the parent scheduled event.
• BUSINESS_GROUP_NAME, TRAINING_CENTRE, ACTIVITY_TYPE, ACTIVITY_NAME — organizational and catalog context for the session.
• BUSINESS_GROUP_ID, ACTIVITY_ID, ACTIVITY_VERSION_ID, EVENT_ID, PARENT_EVENT_ID, TRAINING_CENTER_ID, RCO_ID, OFFERING_ID — keys used for joins and DFF context.
• _DF — the descriptive flexfield context reference that drives view generation.

Common Use Cases and Queries

The view supports queries that list training sessions together with their parent events and catalog activities, and it is also consumed indirectly by flexfield-enabled forms and reports. A typical query filters by business group and session title:

• SELECT session_name, session_date, session_start_time, event_name, training_centre, activity_name FROM otfv_training_event_sessions WHERE business_group_id = :p_bg_id AND session_name LIKE :p_title;
• SELECT event_name, session_name, session_date, time_zone FROM otfv_training_event_sessions ORDER BY event_name, session_date;

Because the view is read-only and secured by business group, it is safe for ad-hoc reporting and for inclusion in custom concurrent programs and XML Publisher data templates that need session-level detail tied to the OTA_EVENTS flexfield.