Search Results otfv_enrolled_events




Overview
Explore in AI Chat

Overview

OTFV_ENROLLED_EVENTS is an APPS-owned database view within the Oracle E-Business Suite Learning Management module (OTA). In the terminology of Oracle's ETRM documentation, it is described as a "business view template from which the flexfield view is generated." This designation means the object is not a standalone reporting view in the conventional sense, but rather a template definition whose column set is consumed by the Oracle Training Administration flexfield view generation mechanism to produce deployable flexfield-enabled views. The view resides in the APPS schema with a VALID status in both Oracle EBS 12.1.1 and 12.2.2.

Functionally, OTFV_ENROLLED_EVENTS presents enrollment and booking information for delegates across training events, offerings, and activities. It joins delegate booking records to event, course, customer, and person data, producing a wide, denormalized projection suitable for flexfield-based reporting, OTA descriptive flexfield generation, and ad hoc querying of enrollment outcomes. Because it is a template, its column list defines the attributes that downstream flexfield views inherit.

Underlying Base Objects

The view is constructed over a substantial set of OTA, HR, and Trading Community Architecture (HZ) base objects, exposed to APPS through synonyms. The principal OTA objects include OTA_EVENTS and OTA_EVENTS_TL, OTA_DELEGATE_BOOKINGS, OTA_BOOKING_STATUS_TYPES and its _TL table, OTA_ACTIVITY_VERSIONS and _TL, OTA_OFFERINGS, OTA_PERFORMANCES, and OTA_LEARNING_OBJECTS. Human Resources and person data are drawn from PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, PER_JOBS, PER_JOB_EXTRA_INFO, PER_ADDRESSES, HR_ALL_ORGANIZATION_UNITS_TL, and HR_LOCATIONS_ALL / HR_LOCATIONS_ALL_TL. Customer-side attributes originate from HZ_CUST_ACCOUNTS, HZ_CUST_ACCOUNT_ROLES, HZ_CUST_ACCT_SITES, HZ_LOCATIONS, HZ_ORG_CONTACTS, HZ_PARTIES, HZ_PARTY_SITES, and HZ_RELATIONSHIPS.

The view also depends on several PL/SQL packages: HR_BIS (used for lookup decoding via BIS_DECODE_LOOKUP), and OTA_GENERAL, OTA_LO_UTILITY, OTA_TDB_BUS, and OTA_UTILITY. The dependence on HR_BIS is significant for SQL tuning, because package function calls in the select list execute per row and can affect performance on large result sets.

Key Columns

Common Use Cases and Queries

Typical uses include enrollment roster reporting, attendance and completion analysis, waitlist monitoring, and external customer training histories. Because it is a template, direct querying is generally acceptable for ad hoc analysis while production reporting should target the generated flexfield view.

  • Roster by event: SELECT event_title, person_name, booking_status FROM otfv_enrolled_events WHERE course_start_date BETWEEN :start_date AND :end_date ORDER BY event_title, person_name.
  • Waitlist volume: SELECT event_title, SUM(waitlisted_enrollment) FROM otfv_enrolled_events GROUP BY event_title HAVING SUM(waitlisted_enrollment) > 0.
  • Completion metrics: SELECT event_title, AVG(test_score), SUM(number_of_successful_places) FROM otfv_enrolled_events WHERE successful_attendance_flag IS NOT NULL GROUP BY event_title.
  • Customer deliveries: SELECT customer_name, event_title, attendance_result FROM otfv_enrolled_events WHERE customer_name IS NOT NULL.

Queries should filter by date or organization to limit the row count, given the breadth of the join and the per-row lookup decoding performed by HR_BIS.