Results for “otfv_hr_restricted_events”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OTFV_HR_RESTRICTED_EVENTS is an APPS-owned business view template in the Oracle E-Business Suite Learning Management module (OTA). It is the source definition from which the Oracle Training Administration flexfield view is generated, and it exposes training event and event-association data restricted to the structures an HR business group controls. In Oracle EBS 12.1.1 and 12.2.2 the object carries a VALID status in the ETRM repository and is classified as a VIEW.

Because it is a business view template rather than a directly maintained entity, the view exists to project descriptive training-event attributes — status, scheduling, pricing, and audience targeting — into a form suitable for HR-facing reporting and integration. The description string embedded in the definition (_DF:OTA:OTA_EVENTS:EVT and _DF:OTA:OTA_EVENT_ASSOCIATIONS:TEA) identifies the two descriptor flexfields the generated view supplies. For the term event_user_status, the relevant projection is the column EVENT_USER_STATUS, which decodes OTA_EVENTS.USER_STATUS against the EVENT_USER_STATUS lookup type.

Underlying Base Objects

The view joins a defined set of base synonyms, views, and packages. Documented dependencies are:

• OTA_EVENTS and OTA_EVENTS_TL — the training event header and its translated descriptive columns.
• OTA_EVENT_ASSOCIATIONS — links an event to an organization, job, or position audience.
• OTA_OFFERINGS_VL and OTA_GENERAL / OTA_UTILITY / OTA_EVT_SHD packages — offering detail and the shared decoding and resource-booking routines.
• HR_ALL_ORGANIZATION_UNITS_TL — referenced twice, aliased BGRT (business group) and ORGT (training center organization).
• PER_JOBS and PER_ALL_POSITIONS — the job and position names attached to each association.
• PO_VENDORS — supplies the supplier name for external training.
• FND_CURRENCIES_VL — the currency name for the standard price.
• HR_BIS — the package whose BIS_DECODE_LOOKUP function expands every coded column into a meaning.

Key Columns

• BUSINESS_GROUP_NAME, BUSINESS_GROUP_ID — the HR business group that owns the event.
• EVENT_TITLE, EVENT_COMMENTS, EVENT_ID — event identity and free-text description.
• EVENT_START_DATE / EVENT_END_DATE, EVENT_START_TIME / EVENT_END_TIME, EVENT_DURATION, EVENT_DURATION_UNITS — the scheduling footprint.
• EVENT_STATUS — OTA_EVENTS.EVENT_STATUS decoded through the SCHEDULED_EVENT_STATUS lookup.
• EVENT_USER_STATUS — OTA_EVENTS.USER_STATUS decoded through the EVENT_USER_STATUS lookup; this is the column users search for under "event_user_status".
• SECURE_EVENT, RESOURCE_BOOKINGS — yes/no flags decoded via HR_BIS and the OTA_EVT_SHD.RESOURCE_BOOKING_FLAG routine.
• TRAINING_CENTER, SUPPLIER_NAME, ORGANIZATION_NAME, JOB_NAME, POSITION_NAME — descriptive context for the event and its audience.
• ENROLLMENT_START_DATE / ENROLLMENT_END_DATE, MINIMUM_ATTENDEES, MAXIMUM_ATTENDEES, STANDARD_PRICE, CURRENCY — enrollment and financial attributes.
• TIME_ZONE, LANGUAGE, EVENT_ASSOCIATION_COMMENTS.

Common Use Cases and Queries

Typical usage is a reporting query that filters on user status or business group. Because the coded columns are already decoded, the results can be presented without additional lookup joins:

• List events by user status within a business group.
• Audit restricted events (SECURE_EVENT = 'Yes') and their audience.
• Report enrollment windows and attendee thresholds for scheduled offerings.

SELECT business_group_name,
       event_title,
       event_start_date,
       event_status,
       event_user_status
FROM   apps.otfv_hr_restricted_events
WHERE  event_user_status = 'Confirmed'
ORDER  BY event_start_date;

All access should be through the APPS schema or a synonym granting the equivalent privileges, and filters should be applied on the decoded columns rather than the underlying lookup codes.