Results for “ota_learning_objects”

50+ results




Overview
Explore in AI Chat

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

Overview

OTA_LEARNING_OBJECTS is the master metadata table in the Oracle E-Business Suite Learning Management module (OTA). It stores metadata describing a discrete piece of online learning content, such as a web-based course, an uploaded document, a SCORM package, or an online test. Administrators create and organize learning objects within the Content tree, where they are arranged into folders and hierarchical parent/child groupings. The table is owned by the OTA schema and is present in both Oracle EBS 12.1.1 and 12.2.2, containing 73 documented columns in the 12.2.2 physical schema.

Functionally, OTA_LEARNING_OBJECTS acts as the central anchor for delivery of online content and assessments. As a consequence, it is referenced by many downstream transactional and structural tables, including learner attempts, offerings, test sections, SCORM objectives, and learner performances. Its heuristic Data Vault classification is a hub, meaning it should be modeled as a business-key-bearing core entity that anchors surrounding satellite and link structures.

Key Information Stored

The table is anchored by a surrogate primary key, OTA_LEARNING_OBJECTS_PK, defined on the column LEARNING_OBJECT_ID. The documented metadata also identifies a unique index, OTA_LEARNING_OBJECTS_UK1, defined on IDENTIFIER, which positions that column as a business-key candidate. Beyond those keys, the most important columns fall into several categories:

Common Use Cases and Queries

The table supports content authoring, catalog browsing, and delivery-time resolution of learning objects. A common query joins it to OTA_LO_FOLDERS to reconstruct the Content tree position of a given object:

  • Retrieve all published learning objects in a folder: SELECT lo.learning_object_id, lo.name, lo.identifier FROM ota_learning_objects lo WHERE lo.folder_id = :p_folder_id AND lo.published_flag = 'Y';
  • Rebuild a parent/child hierarchy: a self-join on lo.parent_learning_object_id = parent.learning_object_id supplies the immediate parent of a child object.
  • Locate assessment content by pointing at TEST_ID and joining to OTA_TEST_SECTIONS for structure.
  • Audit delivery by joining to OTA_ATTEMPTS on LEARNING_OBJECT_ID to identify the actual content consumed in each learner attempt.
  • Report on content-server placement by joining to OTA_CONTENT_SERVERS on CONTENT_SERVER_ID.
  • Segment by external system ingestion using EXTERNAL_SOURCE and EXTERNAL_IDENTIFIER.

Related Objects

The following tables are the most significant objects related to OTA_LEARNING_OBJECTS, based on the documented FK structure:

  • OTA_LO_FOLDERS — referenced via OTA_LEARNING_OBJECTS.FOLDER_ID; defines the Content tree folder container.
  • OTA_CONTENT_SERVERS — referenced via CONTENT_SERVER_ID; identifies the server that hosts the content payload.
  • OTA_CONFERENCE_SERVERS_B — referenced via CONFERENCE_SERVER_ID; supports virtual-classroom delivery.
  • CSS_DEF_LANGUAGES_B — referenced via LANGUAGE_ID; supplies the language of the learning object.
  • OTA_ATTEMPTS — references LEARNING_OBJECT_ID; records learner attempts against the object.
  • OTA_OFFERINGS — references LEARNING_OBJECT_ID; links objects to scheduled catalog offerings.
  • OTA_TEST_SECTIONS — references LEARNING_OBJECT_ID; stores the internal structure of online tests.
  • OTA_LO_SCORM_OBJECTIVES — references LEARNING_OBJECT_ID; captures SCORM objective mapping.
  • OTA_PERFORMANCES — references LEARNING_OBJECT_ID; holds learner performance results tied to the object.