Search Results ota_suppliable_resources




Overview
Explore in AI Chat

Overview

The OTA_SUPPLIABLE_RESOURCES table is a core data object within the Oracle E-Business Suite Learning Management (OTA) module, specifically for versions 12.1.1 and 12.2.2. It serves as the master repository for all resources that can be booked to support the delivery of training events. As defined in the ETRM, a resource is any facility, person, or piece of equipment required to run an event. This table does not store the resource definition itself but rather represents a specific, bookable instance or "supply" of a defined resource. Its primary role is to enable the scheduling and management of these tangible resources against scheduled events, forming the critical link between resource definitions and their actual bookings.

Key Information Stored

The table's central identifier is the SUPPLIED_RESOURCE_ID, which serves as the primary key for each unique, bookable resource instance. The most critical foreign key is RESOURCE_DEFINITION_ID, which links the suppliable instance back to its master definition in the OTA_RESOURCE_DEFINITIONS table. This relationship allows the system to inherit the resource's type, category, and other attributes while tracking specific availability and booking details at the instance level. While the provided ETRM excerpt does not list all columns, typical data stored includes status, effective dates, and organizational assignments to control the availability and lifecycle of each resource supply.

Common Use Cases and Queries

A primary use case is generating reports on resource availability and utilization for capacity planning. Administrators query this table to list all suppliable instances of a specific resource type, such as all projectors or a specific instructor, that are available within a given date range. Another critical operational use is validating and creating bookings, where the system checks this table for an available resource instance before inserting a record into OTA_RESOURCE_BOOKINGS. A common query pattern involves joining to the definitions table to enrich the output with resource names and types:

  • SELECT sr.SUPPLIED_RESOURCE_ID, rd.RESOURCE_NAME, rd.RESOURCE_TYPE FROM OTA_SUPPLIABLE_RESOURCES sr, OTA_RESOURCE_DEFINITIONS rd WHERE sr.RESOURCE_DEFINITION_ID = rd.RESOURCE_DEFINITION_ID AND rd.RESOURCE_TYPE = 'PERSON' AND sr.STATUS = 'ACTIVE';

Related Objects

The OTA_SUPPLIABLE_RESOURCES table sits at the center of the resource management data model, with defined foreign key relationships to several key tables. As documented in the ETRM:

  • OTA_RESOURCE_DEFINITIONS: The foundational relationship. Each row in OTA_SUPPLIABLE_RESOURCES references a master definition via RESOURCE_DEFINITION_ID.
  • OTA_RESOURCE_BOOKINGS: A critical transactional relationship. Bookings for specific event sessions are created against a suppliable resource, linked by SUPPLIED_RESOURCE_ID.
  • OTA_RESOURCE_USAGES: Tracks the actual consumption or usage details of a booked resource, also linked by SUPPLIED_RESOURCE_ID.

These relationships enforce data integrity and ensure that all bookings and usages are tied to a valid, defined resource supply.