Search Results ota_tests




Overview
Explore in AI Chat

Overview

The OTA_TESTS table is a core data object within the Oracle E-Business Suite Learning Management (OTA) module. It stores the behavioral and administrative metadata that defines the properties of a test. A test is a specific type of learning object used to assess learner knowledge or skills. The table maintains a strict one-to-one relationship with the OTA_LEARNING_OBJECTS table, which holds the foundational attributes common to all learning objects, such as title, version, and status. Consequently, OTA_TESTS extends the generic learning object definition with test-specific configuration, controlling how the test is presented, navigated, scored, and evaluated during a learner's assessment.

Key Information Stored

While the specific column list is not detailed in the provided metadata, the table's description indicates it contains properties that determine test behavior. Based on standard OTA functionality, these columns typically govern settings such as the test passing score, the number of attempts allowed, whether questions can be reviewed and changed, the randomization of questions or sections, time limits, and the rules for scoring and feedback. The primary key column is TEST_ID, which uniquely identifies each test record and serves as the foreign key linking back to the corresponding record in OTA_LEARNING_OBJECTS (via its LEARNING_OBJECT_ID).

Common Use Cases and Queries

This table is central to any process involving test configuration, reporting, or data extraction. Administrators and integrators frequently query it to analyze test properties or troubleshoot assessment issues. Common scenarios include generating a list of all active tests with their passing scores, identifying tests that permit multiple attempts, or auditing time-limited assessments. A typical query would join OTA_TESTS to OTA_LEARNING_OBJECTS to get a comprehensive view.

Sample SQL Pattern:
SELECT lot.NAME AS TEST_NAME,
    ots.PASSING_SCORE,
    ots.NUMBER_OF_ATTEMPTS,
    ots.TIME_LIMIT
FROM OTA.OTA_TESTS ots,
       OTA.OTA_LEARNING_OBJECTS lot
WHERE ots.TEST_ID = lot.LEARNING_OBJECT_ID
AND lot.STATUS = 'ACTIVE';

Related Objects

OTA_TESTS is a pivotal table with several key dependencies, as confirmed by the foreign key metadata. It has a direct parent relationship with OTA_LEARNING_OBJECTS. Major child tables that reference TEST_ID include:

  • OTA_TEST_SECTIONS: Stores the sections that organize the questions within a test.
  • OTA_TEST_QUESTIONS: Holds the questions assigned directly to a test, outside of sections.
  • OTA_SECTION_RULES: Contains rules that determine which sections are presented to a learner based on criteria like previous answers.

These relationships illustrate that OTA_TESTS sits at the top of the test definition hierarchy, with its ID propagating down to define the structure and content of the assessment.

  • Table: OTA_TESTS 12.1.1

    owner:OTA,  object_type:TABLE,  fnd_design_data:OTA.OTA_TESTS,  object_name:OTA_TESTS,  status:VALID,  product: OTA - Learning Management ,  description: This table contains additional meta data about the test. The behavior of test test is determined using some of the properties set in this table. There exists a 1:1 relation between the OTA_TESTS and OTA_LEARNING_OBJECTS table. ,  implementation_dba_data: OTA.OTA_TESTS , 

  • Table: OTA_TESTS 12.2.2

    owner:OTA,  object_type:TABLE,  fnd_design_data:OTA.OTA_TESTS,  object_name:OTA_TESTS,  status:VALID,  product: OTA - Learning Management ,  description: This table contains additional meta data about the test. The behavior of test test is determined using some of the properties set in this table. There exists a 1:1 relation between the OTA_TESTS and OTA_LEARNING_OBJECTS table. ,  implementation_dba_data: OTA.OTA_TESTS , 

  • Table: OTA_TEST_SECTIONS 12.1.1

    owner:OTA,  object_type:TABLE,  fnd_design_data:OTA.OTA_TEST_SECTIONS,  object_name:OTA_TEST_SECTIONS,  status:VALID,  product: OTA - Learning Management ,  description: A test can have one or more test sections. For a test to be offered it must have atleast one test section associated with it which contains atleast one question. There is a 1:N relation between the OTA_TESTS and OTA_TEST_SECTIONS ,  implementation_dba_data: OTA.OTA_TEST_SECTIONS , 

  • Table: OTA_TEST_SECTIONS 12.2.2

    owner:OTA,  object_type:TABLE,  fnd_design_data:OTA.OTA_TEST_SECTIONS,  object_name:OTA_TEST_SECTIONS,  status:VALID,  product: OTA - Learning Management ,  description: A test can have one or more test sections. For a test to be offered it must have atleast one test section associated with it which contains atleast one question. There is a 1:N relation between the OTA_TESTS and OTA_TEST_SECTIONS ,  implementation_dba_data: OTA.OTA_TEST_SECTIONS , 

  • View: OTA_TEST_SECTIONS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:OTA.OTA_TEST_SECTIONS_V,  object_name:OTA_TEST_SECTIONS_V,  status:VALID,  product: OTA - Learning Management ,  implementation_dba_data: APPS.OTA_TEST_SECTIONS_V , 

  • View: OTA_TEST_SECTIONS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:OTA.OTA_TEST_SECTIONS_V,  object_name:OTA_TEST_SECTIONS_V,  status:VALID,  product: OTA - Learning Management ,  implementation_dba_data: APPS.OTA_TEST_SECTIONS_V , 

  • Table: OTA_TEST_QUESTIONS 12.2.2

    owner:OTA,  object_type:TABLE,  fnd_design_data:OTA.OTA_TEST_QUESTIONS,  object_name:OTA_TEST_QUESTIONS,  status:VALID,  product: OTA - Learning Management ,  description: This table stores acts as a bridge table between the OTA_TEST_SECTIONS and OTA_QUESTIONS table for test which have a type_flag set to S( Pre Selected)test. This stores which questions will be displayed under which test sections. ,  implementation_dba_data: OTA.OTA_TEST_QUESTIONS , 

  • Table: OTA_SECTION_RULES 12.1.1

    owner:OTA,  object_type:TABLE,  fnd_design_data:OTA.OTA_SECTION_RULES,  object_name:OTA_SECTION_RULES,  status:VALID,  product: OTA - Learning Management ,  description: This table is used to hold the Question Bank Information and the number of questions that should be pulled to generate the test when a user attempts a test. This is only used when the OTA_TEST.TYPE_FLAG is set to D(Rule Based or Dynamic) ,  implementation_dba_data: OTA.OTA_SECTION_RULES , 

  • Table: OTA_TEST_QUESTIONS 12.1.1

    owner:OTA,  object_type:TABLE,  fnd_design_data:OTA.OTA_TEST_QUESTIONS,  object_name:OTA_TEST_QUESTIONS,  status:VALID,  product: OTA - Learning Management ,  description: This table stores acts as a bridge table between the OTA_TEST_SECTIONS and OTA_QUESTIONS table for test which have a type_flag set to S( Pre Selected)test. This stores which questions will be displayed under which test sections. ,  implementation_dba_data: OTA.OTA_TEST_QUESTIONS , 

  • Table: OTA_SECTION_RULES 12.2.2

    owner:OTA,  object_type:TABLE,  fnd_design_data:OTA.OTA_SECTION_RULES,  object_name:OTA_SECTION_RULES,  status:VALID,  product: OTA - Learning Management ,  description: This table is used to hold the Question Bank Information and the number of questions that should be pulled to generate the test when a user attempts a test. This is only used when the OTA_TEST.TYPE_FLAG is set to D(Rule Based or Dynamic) ,  implementation_dba_data: OTA.OTA_SECTION_RULES , 

  • View: OTA_UTEST_QUESTIONS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:OTA.OTA_UTEST_QUESTIONS_V,  object_name:OTA_UTEST_QUESTIONS_V,  status:VALID,  product: OTA - Learning Management ,  implementation_dba_data: APPS.OTA_UTEST_QUESTIONS_V , 

  • View: OTA_UTEST_QUESTIONS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:OTA.OTA_UTEST_QUESTIONS_V,  object_name:OTA_UTEST_QUESTIONS_V,  status:VALID,  product: OTA - Learning Management ,  implementation_dba_data: APPS.OTA_UTEST_QUESTIONS_V ,