Results for “ota_resource_definitions”

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

Overview

OTA_RESOURCE_DEFINITIONS is a core configuration table within the Oracle E-Business Suite Learning Management module (OTA). It stores the unique key flexfield combinations that define the supplied resources available to the enterprise, such as instructors, classrooms, equipment, and other deliverable training assets. Each row represents a discrete, fully qualified resource definition keyed by a surrogate identifier and qualified by the Oracle Applications key flexfield structure.

The table resides in the OTA schema and is documented with 32 columns on the ETRM 12.2.2 physical schema. Because the table is the referenced parent in its foreign key relationship — OTA_SUPPLIABLE_RESOURCES.RESOURCE_DEFINITION_ID points to this table — the heuristic Data Vault classification is hub-leaning. Under that modeling suggestion, OTA_RESOURCE_DEFINITIONS would be treated as a hub of business keys, with the flexfield segments and descriptive attributes acting as satellite context or dependent links.

Key Information Stored

The documented metadata identifies a surrogate primary key and several business-meaningful columns:

• RESOURCE_DEFINITION_ID — the surrogate primary key (OTA_RESOURCE_DEFINITIONS_PK), unique within the table and referenced by dependent child tables.
• RESOURCE_NAME — the descriptive name of the resource definition presented to users.
• SEGMENT1 through SEGMENT20 — the twenty key flexfield segment columns holding the concatenated business identifier of the resource. These segments carry the meaning of the definition and distinguish one resource from another.
• ID_FLEX_NUM — identifies the key flexfield structure applied, enabling the table to support more than one flexfield definition.
• ENABLED_FLAG — indicates whether the definition is active and selectable for scheduling.
• START_DATE_ACTIVE and END_DATE_ACTIVE — date-range control over the validity window of the definition.
• SUMMARY_FLAG — marks summary versus detail flexfield records.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard Oracle Applications who-columns used for auditing and change tracking.

The documented unique index, OTA_RESOURCE_DEFINITIONS_PK, is a surrogate-key construct. The true business key is the combination of flexfield segments plus ID_FLEX_NUM, though no separate business-key unique index appears in the documented metadata.

Common Use Cases and Queries

Report writers and integration developers query this table to enumerate available resources, validate resource references during enrollment or class scheduling, and drive flexfield-based resource reporting.

• List all enabled definitions: SELECT RESOURCE_DEFINITION_ID, RESOURCE_NAME, ENABLED_FLAG FROM OTA.OTA_RESOURCE_DEFINITIONS WHERE ENABLED_FLAG = 'Y';
• Resolve a definition to its suppliable resource: SELECT a.RESOURCE_DEFINITION_ID, a.RESOURCE_NAME, b.* FROM OTA.OTA_RESOURCE_DEFINITIONS a, OTA.OTA_SUPPLIABLE_RESOURCES b WHERE a.RESOURCE_DEFINITION_ID = b.RESOURCE_DEFINITION_ID;
• Filter by flexfield segment for a specific resource category: SELECT RESOURCE_DEFINITION_ID, SEGMENT1, SEGMENT2, RESOURCE_NAME FROM OTA.OTA_RESOURCE_DEFINITIONS WHERE SEGMENT1 = :p_segment1;
• Detect expired or inactive definitions by comparing END_DATE_ACTIVE to the current date for cleanup and data-quality reviews.

Related Objects

The documented foreign key relationship defines the primary dependency:

• OTA_SUPPLIABLE_RESOURCES — references OTA_RESOURCE_DEFINITIONS.RESOURCE_DEFINITION_ID through its own RESOURCE_DEFINITION_ID column. This is the principal child table and links definitions to the bookable resource entities used by scheduling and enrollment.
• OTA_RESOURCE_DEFINITIONS_PK — the primary key index on RESOURCE_DEFINITION_ID, enforcing uniqueness at the database level.

Additional dependencies — such as flexfield value tables (FND_ID_FLEX_STRUCTURES, FND_FLEX_VALUES) for segment validation, and OTA class/scheduling tables that resolve instructors and facilities — follow from the flexfield and resource relationships established here, though they are not enumerated in the supplied metadata.