Search Results ota_frm_obj_inclusions




Overview
Explore in AI Chat

Overview

The OTA_FRM_OBJ_INCLUSIONS table is a core structural component within the Oracle Learning Management (OTA) module of Oracle E-Business Suite. Its purpose is to define the inclusion relationship between a discussion forum and the learning objects it serves. According to the documented metadata, the table specifies that a forum belongs either to a category or to a class. A forum may belong to multiple categories, but it may belong to only one class. Once a forum is associated with a class, it cannot simultaneously be defined under a category, and the reverse constraint also applies. This inclusion model governs how forums are surfaced within the catalog hierarchy of the learning application.

The schema owner is OTA, and the object is documented as VALID in both release 12.1.1 and 12.2.2. The heuristic Data Vault classification mined from the foreign key structure is satellite-leaning, which suggests this table is best modeled as a satellite that carries descriptive and temporal attributes about a parent relationship rather than as a pure hub or link.

Key Information Stored

The table contains twelve documented columns. The unique index OTA_FRM_OBJ_INCLUSIONS_UK1, defined on FORUM_ID, OBJECT_ID, and OBJECT_TYPE, serves as the business-key candidate and primary key constraint. Notable columns include:

  • FORUM_ID — Identifies the forum being included; foreign key to OTA_FORUMS_B.
  • OBJECT_ID — Identifies the category or class to which the forum is attached.
  • OBJECT_TYPE — Distinguishes whether the OBJECT_ID refers to a category or a class, and drives the mutual-exclusion rule described above.
  • START_DATE_ACTIVE / END_DATE_ACTIVE — Effective-dating pair that bounds the period during which the inclusion is valid.
  • PRIMARY_FLAG — Marks the primary inclusion when a forum is attached to more than one category.
  • OBJECT_VERSION_NUMBER — Optimistic locking column used by the OTA framework and OA Framework pages.
  • CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard WHO audit columns maintained by the EBS application.

The surrogate primary key is the composite unique index itself; there is no separate single-column surrogate identifier documented.

Common Use Cases and Queries

Typical scenarios include determining which forums have been attached to a given class or category, validating the single-class constraint before an insert, and reporting on currently active inclusions.

  • Find active inclusions for a forum:
    SELECT OBJECT_ID, OBJECT_TYPE FROM OTA.OTA_FRM_OBJ_INCLUSIONS WHERE FORUM_ID = :p_forum_id AND SYSDATE BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, SYSDATE+1);
  • List all forums for a class or category:
    SELECT i.FORUM_ID, f.NAME FROM OTA.OTA_FRM_OBJ_INCLUSIONS i, OTA.OTA_FORUMS_B f WHERE i.FORUM_ID = f.FORUM_ID AND i.OBJECT_ID = :p_object_id AND i.OBJECT_TYPE = :p_type;
  • Enforce the documented hierarchy rule by checking that no forum has rows with an OBJECT_TYPE of 'CLASS' together with an active row of OBJECT_TYPE 'CATEGORY'.
  • Reconciliation reporting on inclusions whose END_DATE_ACTIVE has passed but whose records remain flagged active.

Related Objects

  • OTA_FORUMS_B — Parent table referenced by OTA_FRM_OBJ_INCLUSIONS.FORUM_ID.
  • OTA_FORUMS_TL — Translation table for forum names used in reporting joins.
  • OTA_LEARNER_ENRL — Enrollment data that can be joined via the class identified by OBJECT_ID.
  • OTA_OBJECTIVES_B — Learning objects that may participate in forum inclusion hierarchies.
  • OTA_CATEGORIES_B — Category definitions that may populate OBJECT_ID.
  • OTA_CLASSES_B — Class definitions that may populate OBJECT_ID.

Together these objects form the catalog and discussion-forum backbone of the Learning Management module.