Search Results assignment_organization




Overview
Explore in AI Chat

Overview

OTFV_INT_TRAINING_EVENT_ENROLS is an APPS-owned Business Intelligence System (BIS) view in Oracle EBS 12.1.1 and 12.2.2, registered under FND Design Data OTA.OTFV_INT_TRAINING_EVENT_ENROLS. It presents internal training classes attended by employees within an enterprise, consolidating delegate booking, event, offering, performance, and assignment context into a single denormalised read model. Because the view is typed as a BIS view rather than a transactional entity, it is intended for reporting, downstream extracts, and integration pipelines rather than for DML. Its design flattens the OTA (Oracle Training Administration / Learning Management) enrolment model together with core HR assignment attributes, so a single row answers both "what training did the person attend" and "what organisational position did they hold at the time". The view is documented as VALID in the APPS schema.

Underlying Base Objects

The view is defined over OTA and PER synonyms, with supporting packaged logic. Training-side sources include OTA_DELEGATE_BOOKINGS (the delegate enrolment record), OTA_EVENTS and OTA_EVENTS_TL (event header and translated name), OTA_OFFERINGS, OTA_PERFORMANCES, OTA_ACTIVITY_DEFINITIONS with OTA_ACTIVITY_DEFINITIONS_TL and OTA_ACTIVITY_VERSIONS with OTA_ACTIVITY_VERSIONS_TL (course/activity content), OTA_LEARNING_OBJECTS, OTA_CATEGORY_USAGES with OTA_CATEGORY_USAGES_TL, and OTA_BOOKING_STATUS_TYPES with OTA_BOOKING_STATUS_TYPES_TL. Human-resources sources are PER_ALL_PEOPLE_F (person), PER_ALL_ASSIGNMENTS_F (assignment), PER_JOBS and PER_JOB_EXTRA_INFO, HR_ALL_ORGANIZATION_UNITS_TL, HR_LOCATIONS_ALL_TL, and PER_ADDRESSES for correspondence details. Packaged objects HR_BIS, HR_GENERAL, OTA_GENERAL, OTA_TDB_BUS, and OTA_UTILITY supply business-group security, date-tracked effective-date resolution, and translated/coded value derivation. The heavy use of effective-dated PER tables explains why assignment attributes such as organisation, job, and location may be resolved as of a derived date.

Key Columns

The view exposes descriptive identity columns (BUSINESS_GROUP_NAME, PERSON_NAME), event descriptors (EVENT_NAME, EVENT_TYPE, EVENT_COMMENTS), scheduling columns (TIME_ZONE, COURSE_START_DATE/TIME, COURSE_END_DATE/TIME, DATE_BOOKING_PLACED, TOTAL_TRAINING_TIME, ACTIVITY_TYPE, ACTIVITY_NAME, CATEGORY_NAME, LANGUAGE), and outcome columns (ATTENDANCE_RESULT, FAILURE_REASON, SUCCESSFUL_ATTENDANCE_FLAG, TEST_SCORE, PLAYER_STATUS, NUMBER_OF_MODULES_COMPLETED, TOTAL_MODULES). Operational enrolment columns include BOOKING_STATUS, SOURCE_OF_BOOKING_MEANING, CORRESPONDENCE_MEANING, CORRESPONDENCE_PHONE/FAX/EMAIL, ENROLMENT_COMMENTS, SPECIAL_REQUIREMENTS, NUMBER_OF_PLACES, and NUMBER_OF_SUCCESSFUL_PLACES. The assignment-oriented columns most relevant to the "assignment_organization" search are ASSIGNMENT_NUMBER, ASSIGNMENT_ORGANIZATION, ASSIGNMENT_LOCATION, ASSIGNMENT_JOB_CATEGORY, and ASSIGNMENT_JOB; these describe the delegate's organisational placement alongside CURRENT_EMPLOYEE_FLAG and INTERNAL_BOOKING_FLAG. ORGANIZATION_NAME and TRAINING_CENTER describe the delivering organisation and venue rather than the delegate's own assignment.

Common Use Cases and Queries

Typical uses include training-completion audits, organisational training-cost and compliance analysis by department, and feeds into a data warehouse. To compare training uptake by employee organisation, aggregate on ASSIGNMENT_ORGANIZATION. To identify non-compliant attendees, filter on SUCCESSFUL_ATTENDANCE_FLAG.

  • Attendance by organisation: SELECT assignment_organization, COUNT(*) FROM apps.otfv_int_training_event_enrols WHERE successful_attendance_flag = 'Y' GROUP BY assignment_organization;
  • Detailed enrolment extract: SELECT person_name, event_name, course_start_date, attendance_result, assignment_job, assignment_location FROM apps.otfv_int_training_event_enrols WHERE course_start_date BETWEEN :from_date AND :to_date;
  • Internal delegates only: SELECT person_name, event_name, booking_status FROM apps.otfv_int_training_event_enrols WHERE internal_booking_flag = 'Y';

Because the view joins many effective-dated tables, queries should constrain date ranges and business group where possible to control cost.