Results for “activity_category”

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

Overview

OTA_ACT_CAT_INCLUSIONS is a transactional table in the Oracle E-Business Suite Learning Management (OTA) module. It stores course category inclusion records, where an inclusion specifies that a particular course or offering (identified by an activity version and event) belongs to a defined category type. This enables the categorization of learning activities for classification, reporting, enrollment eligibility, and content organization purposes.

From a dimensional modeling perspective, the heuristic Data Vault classification for this table is link. This classification is inferred from the foreign key structure: the table functions as an associative entity resolving a many-to-many relationship between activity versions, events, and category usages, rather than acting as a hub or satellite of descriptive attributes.

Key Information Stored

Each row associates a learning activity with a category. The most significant columns are:

• ACTIVITY_VERSION_ID — Foreign key to OTA_ACTIVITY_VERSIONS; identifies the specific versioned activity (course/offering) being categorized. Part of both unique keys.
• EVENT_ID — Foreign key to OTA_EVENTS; identifies the event (scheduled instance) context of the inclusion. Part of both unique keys.
• ACTIVITY_CATEGORY — The category value assigned to the activity; part of primary key UK2.
• CATEGORY_USAGE_ID — Foreign key to OTA_CATEGORY_USAGES; defines the usage/type context of the category. Part of primary key UK3.
• PRIMARY_FLAG — Indicates whether this inclusion is the primary category for the activity.
• START_DATE_ACTIVE / END_DATE_ACTIVE — Date-bounded validity of the inclusion, supporting effective-dated categorization.
• COMMENTS — Free-text notes about the inclusion.
• OBJECT_VERSION_NUMBER — Optimistic locking column for concurrent update control.
• ACI_INFORMATION_CATEGORY and ACI_INFORMATION1–ACI_INFORMATION20 — A set of 20 descriptive flexfield (DFF) columns for extensible, customer-defined attributes.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY — Standard Oracle WHO audit columns tracking who created and last modified the record.

Two unique indexes serve as business-key candidates: OTA_ACT_CAT_INCLUSIONS_UK2 (ACTIVITY_VERSION_ID, EVENT_ID, ACTIVITY_CATEGORY) and OTA_ACT_CAT_INCLUSIONS_UK3 (ACTIVITY_VERSION_ID, EVENT_ID, CATEGORY_USAGE_ID). No single surrogate sequence column is documented; the table relies on these composite unique keys for row identity.

Common Use Cases and Queries

Typical applications include identifying all categories to which a course belongs, locating courses within a category type for catalog display, and validating enrollment eligibility against category restrictions. A representative query joins to the category usage definition:

• Reporting: SELECT aci.ACTIVITY_VERSION_ID, aci.EVENT_ID, aci.ACTIVITY_CATEGORY FROM OTA_ACT_CAT_INCLUSIONS aci WHERE aci.CATEGORY_USAGE_ID = :usage_id AND SYSDATE BETWEEN NVL(aci.START_DATE_ACTIVE, SYSDATE) AND NVL(aci.END_DATE_ACTIVE, SYSDATE);
• Primary category lookup: filter on PRIMARY_FLAG = 'Y' to retrieve the leading category per activity.
• Extensibility reporting: query the ACI_INFORMATIONn DFF columns once the descriptive flexfield segments have been defined and mapped.

Related Objects

The following objects are the most significant referenced or referencing entities:

• OTA_ACTIVITY_VERSIONS — joined via ACTIVITY_VERSION_ID; the versioned activity master.
• OTA_EVENTS — joined via EVENT_ID; the scheduled event context.
• OTA_CATEGORY_USAGES — joined via CATEGORY_USAGE_ID; defines how the category is used.
• OTA_CATEGORIES_B / OTA_CATEGORIES_TL — the category definitions underlying ACTIVITY_CATEGORY values.
• OTA_ACTIVITIES_B / OTA_ACTIVITIES_TL — the parent activity definitions reached through OTA_ACTIVITY_VERSIONS.
• OTA_CATEGORY_INCLUSIONS (related inclusion structures) — companion inclusion tables sharing similar categorization semantics.

These relationships make OTA_ACT_CAT_INCLUSIONS a central associative table for Learning Management category modeling.