Results for “ota_scorm_obj_attempts”

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

Overview

OTA_SCORM_OBJ_ATTEMPTS is a transactional table in the Oracle E-Business Suite Learning Management (OTA) module. It resides in the OTA schema and is classified as VALID in ETRM 12.1.1 and 12.2.2. The table stores the raw SCORM (Sharable Content Object Reference Model) data captured from e-learning content during a specific learner attempt. Specifically, it records lesson status, score values, and identifier changes reported by the content package as the learner interacts with the objective. When an attempt concludes, this raw data is consumed by the application to update the learner's overall performance on the associated objective, which is maintained in the broader SCORM objective tracking structure.

From a data modeling perspective, the heuristic Data Vault classification for this table is a link. This is derived from the foreign key structure: the table connects the attempt context (OTA_ATTEMPTS) with the SCORM objective definition (OTA_SCORM_OBJECTIVES), and each row carries descriptive attributes that behave as satellite-style payload. The classification is a modeling suggestion rather than a documented architectural decision, but it aligns with the table's role as a junction capturing per-attempt objective-level detail.

Key Information Stored

The table contains 24 documented columns in ETRM 12.2.2. The most significant columns and their roles are:

• OBJECTIVE_ATTEMPT_ID — The surrogate primary key, defined by the unique index OTA_SCORM_OBJ_ATTEMPTS_PK. It uniquely identifies each objective-level attempt record.
• ATTEMPT_ID — Foreign key to OTA_ATTEMPTS, linking this raw SCORM data to the parent learner attempt.
• OBJECTIVE_ID — Foreign key to OTA_SCORM_OBJECTIVES, identifying the SCORM objective being tracked.
• SCORM_LEARNER_ATTEMPT_ID — The learner attempt identifier as reported by the SCORM content, useful for reconciliation with external LMS content logs.
• RAW_STATUS — The lesson status string set directly by the SCORM content (for example, passed, failed, completed, incomplete).
• RAW_SCORE — The raw score value submitted by the content package.
• RAW_IDENTIFIER — The identifier change or objective identifier reported by the content.
• SUCCESS_STATUS, COMPLETION_STATUS — Normalized status fields used to determine objective success and completion outcomes.
• SCALED_SCORE, MIN_SCORE, MAX_SCORE — Score normalization parameters captured during the attempt.
• PROGRESS_MEASURE — The progress value reported for the objective.
• USER_ID, USER_TYPE, BUSINESS_GROUP_ID — Learner identity, user classification, and multi-tenant business group context.
• INTERNAL_STATE — Internal processing state used by the application.
• OBJECT_VERSION_NUMBER — Optimistic locking column.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns.

OBJECTIVE_ATTEMPT_ID is the only documented unique index key; no separate business-key unique index is documented.

Common Use Cases and Queries

Typical usage centers on reporting learner SCORM performance and diagnosing status/score discrepancies between raw content output and the normalized outcome on the objective.

• Reporting all raw SCORM submissions for a given attempt:

  SELECT objective_attempt_id, objective_id, raw_status, raw_score, scaled_score, success_status
  FROM   ota_scorm_obj_attempts
  WHERE  attempt_id = :attempt_id;

• Aggregating attempt data per objective across learners:

  SELECT o.objective_id, COUNT(*) attempts, AVG(a.scaled_score) avg_scaled_score
  FROM   ota_scorm_obj_attempts a, ota_scorm_objectives o
  WHERE  a.objective_id = o.objective_id
  GROUP BY o.objective_id;

• Auditing score submission history by date range using CREATION_DATE and LAST_UPDATE_DATE.
• Reconciling content-reported identifiers via RAW_IDENTIFIER and SCORM_LEARNER_ATTEMPT_ID against external SCORM logs.

Related Objects

• OTA_ATTEMPTS — parent attempt record; joined via OTA_SCORM_OBJ_ATTEMPTS.ATTEMPT_ID = OTA_ATTEMPTS.ATTEMPT_ID.
• OTA_SCORM_OBJECTIVES — SCORM objective definition; joined via OTA_SCORM_OBJ_ATTEMPTS.OBJECTIVE_ID = OTA_SCORM_OBJECTIVES.OBJECTIVE_ID.
• OTA_SCORM_OBJ_ATTEMPTS_PK — primary key index on OBJECTIVE_ATTEMPT_ID.
• OTA learner performance / objective summary tables — consume this raw data to update overall objective performance when an attempt finishes.
• OTA content and SCORM content object tables — provide the content structure that generates the raw status and score values captured here.