Search Results duration_units_code




Overview
Explore in AI Chat

Overview

OTFV_SCHEDULED_TRAINING_EVENTS is an APPS-owned Business Intelligence (BIS) view within the Oracle E-Business Suite OTA (Oracle Training Administration) product family. It is registered in FND Design Data under the identifier OTA.OTFV_SCHEDULED_TRAINING_EVENTS and holds a VALID status in both EBS 12.1.1 and 12.2.2. The view presents scheduled training events offered by an enterprise, where a scheduled event is defined as a specific instance of a training activity onto which students are enrolled. Rather than exposing raw transactional tables, the view surfaces a denormalized, business-friendly projection intended for reporting, ad hoc inquiry, and downstream integration scenarios. The BIS designation indicates the view is optimized for read-only analytical consumption rather than transactional update, and it provides a stable, named interface against the underlying OTA schema objects for both Discoverer-style reporting and custom SQL.

Underlying Base Objects

The view is defined over a documented set of base tables, synonyms, and packages in the OTA schema, joined together to resolve event, activity, offering, customer, and currency context. Its dependencies include OTA_EVENTS and OTA_EVENTS_TL for the scheduled event instance and its translated descriptive name and comments; OTA_ACTIVITY_DEFINITIONS, OTA_ACTIVITY_DEFINITIONS_TL, OTA_ACTIVITY_VERSIONS, and OTA_ACTIVITY_VERSIONS_TL for the parent training activity, its version, and translated text; OTA_OFFERINGS for the offering linkage; OTA_BOOKING_STATUS_TYPES, OTA_DELEGATE_BOOKINGS, OTA_CATEGORY_USAGES, and OTA_CATEGORY_USAGES_TL for booking, delegate, and categorization context; HR_ALL_ORGANIZATION_UNITS_TL for the training center and business group organization names; PO_VENDORS for supplier/ sponsor identification; and FND_CURRENCIES_VL for the currency display. Computational and business logic is supplied through the HR_BIS, OTA_GENERAL, OTA_UTILITY, and OTA_VIEWS_PKG packages, which resolve derived measures and statuses such as the confirmed, successful, and overall student counts and the event status code translations.

Key Columns

The column set covers scheduling, capacity, pricing, and count metrics. Core scheduling columns include EVENT_NAME, EVENT_COMMENTS, EVENT_START_DATE, EVENT_END_DATE, EVENT_START_TIME, EVENT_END_TIME, TIME_ZONE, DURATION, and DURATION_UNITS (with the coded DURATION_UNITS_CODE). Enrollment window columns are ENROLMENT_START_DATE and ENROLMENT_END_DATE, and location context is provided by TRAINING_CENTER and its TRAINING_CENTER_ID. Status flags include EVENT_STATUS, USER_STATUS, EVENT_STATUS_CODE, EVENT_FULL_FLAG, EVENT_TENTATIVE_FLAG, SECURE_EVENT_FLAG, and RESTRICTIONS_APPLY. Capacity and pricing columns include AVAILABLE_PLACES, MINIMUM_ATTENDEES, MAXIMUM_ATTENDEES, MAXIMUM_INTERNAL_ATTENDEES, STANDARD_PRICE, and CURRENCY_CODE.

The count columns are central to the user's interest in confirmed_int_student_count. The view exposes INTERNAL_STUDENT_COUNT, EXTERNAL_STUDENT_COUNT, SUCCESSFUL_INT_STUDENT_COUNT, SUCCESSFUL_EXT_STUDENT_COUNT, CONFIRMED_INT_STUDENT_COUNT, and CONFIRMED_EXT_STUDENT_COUNT. CONFIRMED_INT_STUDENT_COUNT reports the number of internal delegates whose bookings are in a confirmed booking status, making it the key metric for assessing committed internal demand against MAXIMUM_INTERNAL_ATTENDEES and MINIMUM_ATTENDEES. Identity and join keys include EVENT_ID, ACTIVITY_ID, ACTIVITY_VERSION_ID, OFFERING_ID, BUSINESS_GROUP_ID, BUSINESS_GROUP_NAME, and RCO_ID.

Common Use Cases and Queries

Typical uses include measuring enrollment fill rates, comparing confirmed internal demand against capacity, identifying events nearing the minimum attendee threshold, and feeding BI extracts. A confirmation-vs-capacity query might read:

  • SELECT event_name, event_start_date, minimum_attendees, maximum_internal_attendees, confirmed_int_student_count, internal_student_count, (confirmed_int_student_count / maximum_internal_attendees) * 100 pct_filled FROM otfv_scheduled_training_events WHERE event_start_date >= TRUNC(SYSDATE) AND maximum_internal_attendees IS NOT NULL ORDER BY pct_filled DESC;
  • SELECT event_name, available_places, confirmed_int_student_count, confirmed_ext_student_count, event_full_flag FROM otfv_scheduled_training_events WHERE event_full_flag = 'Y' AND business_group_name = :p_bg;
  • SELECT training_center, COUNT(*) events, SUM(confirmed_int_student_count) total_confirmed_internal FROM otfv_scheduled_training_events GROUP BY training_center;

Because it is a non-updatable BI view, it is suited to SELECT-only reporting and integration extraction, not DML.