Search Results assignment_location

Overview

OTFV_INT_TRAINING_EVENT_ENROLS is an APPS-owned business view template in the Oracle Learning Management (OTA) module, exposed for Oracle E-Business Suite 12.1.1 and 12.2.2 reporting and integration. Its name follows the OTFV prefix convention used by Oracle Training and Event Management flexfield views: the object is generated as a flexfield-enabled view derived from a business view template, allowing descriptive flexfield segments to be appended dynamically at runtime without altering the underlying SQL. The view is documented with a status of VALID and presents a consolidated, delegate-level picture of training event enrolments — one row per delegate booking against a training activity performance — combining learner identity, assignment context, event scheduling, booking status, and attendance and assessment outcomes. Because it joins across HR, OTA, and PER objects and resolves several coded columns through lookup decoding, it is intended as a reporting and integration surface rather than a transactional entry point. The user search term internal_booking_flag maps directly to a column delivered by this view, which indicates whether a booking was created internally by the training administrator (for example, a nomination or mass enrolment) rather than through learner self-service.

Underlying Base Objects

The view is defined over a substantial set of documented base objects spanning several schemas exposed as APPS synonyms. Core OTA tables include OTA_EVENTS and OTA_EVENTS_TL (event header and title), OTA_OFFERINGS, OTA_PERFORMANCES, OTA_ACTIVITY_DEFINITIONS and OTA_ACTIVITY_DEFINITIONS_TL, OTA_ACTIVITY_VERSIONS and OTA_ACTIVITY_VERSIONS_TL (activity catalogue and version), OTA_DELEGATE_BOOKINGS (the delegate booking record that anchors each row), OTA_BOOKING_STATUS_TYPES and OTA_BOOKING_STATUS_TYPES_TL (booking status), OTA_CATEGORY_USAGES and OTA_CATEGORY_USAGES_TL (activity category), and OTA_LEARNING_OBJECTS. Human resources and person objects supply learner and organisation context: 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_TL. The view also invokes the packages HR_BIS, HR_GENERAL, OTA_GENERAL, OTA_TDB_BUS, and OTA_UTILITY for decoding and business logic. Referential joins flow from the delegate booking to the performance and offering, from the booking to the learner's person and assignment records, and from the assignment to job, location, and organisation attributes.

Key Columns

• INTERNAL_BOOKING_FLAG — decoded via HR_BIS.BIS_DECODE_LOOKUP('YES_NO', TDB.INTERNAL_BOOKING_FLAG); distinguishes internally created bookings from those originating through self-service enrolment.
• PERSON_NAME / ASSIGNMENT_NUMBER / ASSIGNMENT_ORGANIZATION / ASSIGNMENT_LOCATION — learner identity and assignment context drawn from PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, HR locations and organisations.
• EVENT_NAME, EVENT_TYPE, COURSE_START_DATE, COURSE_START_TIME, COURSE_END_DATE, TIME_ZONE — event scheduling attributes from OTA_EVENTS.
• DATE_BOOKING_PLACED, BOOKING_STATUS, NUMBER_OF_PLACES — booking metadata from OTA_DELEGATE_BOOKINGS and booking status types.
• ATTENDANCE_RESULT, SUCCESSFUL_ATTENDANCE_FLAG, FAILURE_REASON — attendance outcome fields, with flags and reasons decoded through lookups.
• TEST_SCORE, TOTAL_TIME_TAKEN, PLAYER_STATUS, NUMBER_OF_MODULES_COMPLETED, TOTAL_MODULES — e-learning and assessment measures including content player status.
• TRAINING_CENTER, ACTIVITY_TYPE, ACTIVITY_NAME, CATEGORY_NAME, LANGUAGE, ORGANIZATION_NAME, BUSINESS_GROUP_NAME — descriptive and categorisation attributes for reporting groupings.
• CURRENT_EMPLOYEE_FLAG — decoded YES_NO indicator of whether the learner is a current employee.

Common Use Cases and Queries

Typical uses include enrolment and attendance reporting, internal versus self-service booking analysis, e-learning completion tracking, and integration extracts into external learning or HR systems. A representative query isolating internally booked enrolments:

SELECT person_name, event_name, course_start_date, booking_status, internal_booking_flag
FROM apps.otfv_int_training_event_enrols
WHERE internal_booking_flag = 'Y'
ORDER BY course_start_date DESC;

Attendance and completion reporting by organisation follows a similar pattern:

SELECT assignment_organization, event_name, person_name,
successful_attendance_flag, test_score, number_of_modules_completed
FROM apps.otfv_int_training_event_enrols
WHERE attendance_result IS NOT NULL;

Because the view decodes lookup values at query time and joins several package functions, filtering on decoded columns such as INTERNAL_BOOKING_FLAG is supported but may inhibit index usage on the base tables; restrict on DATE_BOOKING_PLACED or event dates where possible for performance.