Results for “otfv_missing_req_resources”

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

Overview

OTFV_MISSING_REQ_RESOURCES is an Oracle E-Business Suite business view owned by the APPS schema and defined within the OTA (Oracle Training Administration / Learning Management) product family. It functions as a business view template from which a flexfield view is generated, and it is delivered in a VALID state in EBS 12.1.1 and 12.2.2. The view answers a specific operational question: which required resources on a training event's activity version have no corresponding confirmed booking? It therefore supports the scheduling, resource planning, and logistics components of Learning Management, where instructors, rooms, equipment, and other suppliable resources must be secured before an offering can be delivered.

Because the view exposes EVENT_TITLE among its columns, it is frequently located when users search on that term. Reporting and integration consumers can retrieve event-level context alongside the resource shortfall, making it suitable for exception dashboards, alerting workflows, and prerequisite validation before an event is published or confirmed.

Underlying Base Objects

The documented referenced base objects are OTA_EVENTS (with its translatable synonym OTA_EVENTS_TL), OTA_ACTIVITY_VERSIONS (and OTA_ACTIVITY_VERSIONS_TL), OTA_SUPPLIABLE_RESOURCES (and OTA_SUPPLIABLE_RESOURCES_TL), OTA_RESOURCE_USAGES, OTA_RESOURCE_BOOKINGS, OTA_OFFERINGS, plus the HR_BIS and OTA_GENERAL packages. The view joins OTA_EVENTS to OTA_ACTIVITY_VERSIONS on ACTIVITY_VERSION_ID, links resource usages to activity versions through OTA_RESOURCE_USAGES, and resolves the supplied resource through OTA_SUPPLIABLE_RESOURCES. The HR_BIS package supplies BIS_DECODE_LOOKUP for translating RESOURCE_TYPE codes, while OTA_GENERAL.GET_BUSINESS_GROUP_ID enforces multi-org security through an NVL filter on BUSINESS_GROUP_ID.

The result set is a UNION of two branches. The first returns required resources (REQUIRED_FLAG = 'Y') that have a SUPPLIED_RESOURCE_ID but no confirmed booking in OTA_RESOURCE_BOOKINGS (STATUS = 'C') meeting the required quantity. The second returns required resource usages where SUPPLIED_RESOURCE_ID is null, capturing generic requirements not yet tied to a specific resource.

Key Columns

• RESOURCE_TYPE — decoded resource type label produced through HR_BIS.BIS_DECODE_LOOKUP on the RESOURCE_TYPE lookup.
• RESOURCE_NAME — name of the suppliable resource; null in the unassigned-requirement branch.
• ACTIVITY_NAME — the activity version name (TAV.VERSION_NAME) associated with the event.
• EVENT_TITLE — the event title (EVT.TITLE), the primary descriptor for the training event.
• EVENT_ID, ACTIVITY_VERSION_ID, SUPPLIED_RESOURCE_ID, OFFERING_ID, RCO_ID — surrogate keys linking the shortfall back to the event, version, resource, offering, and resource catalog object.

Common Use Cases and Queries

Typical usage includes exception reports listing events whose required resources remain unbooked, alerts to learning administrators before an event dates, and validation in custom concurrent programs. A basic query is:

SELECT event_title, activity_name, resource_type, resource_name FROM apps.otfv_missing_req_resources ORDER BY event_title;

Filtering to a specific event narrows the output: SELECT resource_type, resource_name FROM apps.otfv_missing_req_resources WHERE event_id = :p_event_id;. Because business group filtering is embedded, results remain secured to the session's operating unit context. The view is read-only (WITH READ ONLY) and should be treated as a reporting construct rather than a data-maintenance path.