My Oracle Support Banner

Useful details regarding the OTA_ATTEMPTS Table. (Doc ID 2377573.1)

Last updated on JULY 19, 2023

Applies to:

Oracle Learning Management - Version 11.5.10.2 and later
Information in this document applies to any platform.

Purpose

 This Document covers important details on the functionality of the OTA_ATTEMPTS when a course it is played or Attempted by the learner.

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 Scope
 Details
  How is the OTA_ATTEMPTS Populated?
 When are the RAW_SCORE and RAW_STATUS Populated?
 Exactly what data is passed to the  ATTEMPT_STATUS, PREVIOUS_STATUS, RAW_STATUS, RAW_SCORE Columns?
 What does N, I, C, F, P means in the columns?
 What is the sequence the column ATTEMPT_STATUS is updated?
 Troubleshooting suggestions:
 FND log sample output:
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.