Search Results ota_act_cat_inclusions




Overview
Explore in AI Chat

Overview

The OTA_ACT_CAT_INCLUSIONS table is a core data object within the Oracle E-Business Suite Learning Management (OTA) module. It serves as a junction table that defines the relationship between learning activities (courses) and the classification categories used to organize them. Its primary function is to specify that a particular course, represented by an activity version or a specific event instance, is included within a defined category. This categorization is essential for structuring the learning catalog, enabling course discovery, reporting, and administrative functions such as targeted enrollment and resource allocation based on course type or subject area.

Key Information Stored

The table stores the minimal set of foreign key columns necessary to establish the link between a course and its category. As per the provided metadata, the critical columns are ACTIVITY_VERSION_ID, EVENT_ID, ACTIVITY_CATEGORY, and CATEGORY_USAGE_ID. The ACTIVITY_VERSION_ID references a specific version of a course from the OTA_ACTIVITY_VERSIONS table, while EVENT_ID can link to a specific scheduled offering from OTA_EVENTS. The ACTIVITY_CATEGORY column holds the classification code, and CATEGORY_USAGE_ID provides context for how the category is applied. The table's two unique keys (UK2 and UK3) enforce data integrity, ensuring a course is not duplicated within the same category context. The presence of both ACTIVITY_VERSION_ID and EVENT_ID allows for categorization at both the course definition and the specific event level.

Common Use Cases and Queries

A primary use case is generating reports or building catalog interfaces that list all courses belonging to a specific category, such as "Technical Skills" or "Compliance." Administrators often query this table to validate or audit course classifications. Given the user's search for "activity_version_id," a typical query pattern would involve joining to the activity versions table to retrieve course details for a specific category.

  • Find all courses in a specific category:
    SELECT av.activity_version_id, av.title FROM ota_act_cat_inclusions aci JOIN ota_activity_versions av ON aci.activity_version_id = av.activity_version_id WHERE aci.activity_category = '&CATEGORY_CODE';
  • Find all categories for a specific course version:
    SELECT activity_category FROM ota_act_cat_inclusions WHERE activity_version_id = &VERSION_ID;

Related Objects

This table has direct foreign key dependencies on two primary master tables, forming the core of its relationships. As documented, OTA_ACTIVITY_VERSIONS is referenced via ACTIVITY_VERSION_ID, and OTA_EVENTS is referenced via EVENT_ID. It is also intrinsically linked to the underlying category definitions and usage rules, likely within the OTA_CATEGORY_USAGES table or related setup tables, though not explicitly listed in the provided excerpt. This table is a key source for any reporting view or API that needs to filter or group learning activities by their assigned categories, making it a critical component for data extraction and integration within the OTA module.