Results for “ota_response_values”

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

Overview

OTA_RESPONSE_VALUES is a Learning Management (OTA) table within the Oracle E-Business Suite 12.1.1 and 12.2.2 data model. It stores the discrete answer or selection options that belong to a question or response type. As stated in the ETRM documentation, the table "stores the response values for a question," and there is a documented 1:N relationship between OTA_RESPONSE_TYPES (the parent) and OTA_RESPONSE_VALUES (the child). In practical terms, each row defines one selectable value — for example, one choice on a multiple-choice question, or one valid answer used when scoring an online test or survey delivered through OTA (iLearning/Oracle Learning Management).

Under the heuristic Data Vault classification mined from the foreign key structure, this object is satellite-leaning. That is a modeling suggestion rather than a physical constraint: the table carries descriptive attributes (text, sequence, correctness flag, effective dates) that hang off a parent key, which is characteristic of satellite behavior. It also behaves partly as a link because OTA_UTEST_RESPONSES references it, so the surrogate key participates in downstream relationships. Treating OTA_RESPONSE_VALUES as a satellite keyed to OTA_RESPONSE_TYPES aligns well with the documented 1:N cardinality.

Key Information Stored

The table physically consists of 14 documented columns in the 12.2.2 schema. The most significant of these are:

• RESPONSE_VALUE_ID — the surrogate primary key, enforced by the unique index OTA_RESPONSE_VALUES_PK. This is the column users most often search on ("response_value_id"). No separate business-key unique index is documented beyond the primary key, so RESPONSE_VALUE_ID is the single documented unique candidate.
• RESPONSE_TYPE_ID — the foreign key to OTA_RESPONSE_TYPES, establishing the parent question or response type to which this value belongs.
• BUSINESS_GROUP_ID — the multi-tenant / operating unit partition key standard across OTA and HRMS-style tables, controlling which business group owns the row.
• CORRECT_FLAG — indicates whether this response value is a correct answer, directly supporting test scoring in online assessments.
• SEQUENCE — controls the display or presentation order of the values within a question.
• TEXT — the displayed or stored content of the response value, such as the answer label.
• START_DATE_ACTIVE / END_DATE_ACTIVE — effective-dating range governing when the value is valid for use.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the OAF/ADF framework for concurrent-update protection.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard WHO audit columns tracking row creation and modification.

Common Use Cases and Queries

Typical scenarios include retrieving all valid answers for a given question, reporting on correct-answer configuration for test banks, and validating captured test responses. A representative query joins the parent response type to enumerate live values, ordered for display:

• SELECT rv.response_value_id, rv.text, rv.correct_flag, rv.sequence FROM ota_response_values rv, ota_response_types rt WHERE rv.response_type_id = rt.response_type_id AND rv.response_type_id = :p_response_type_id AND SYSDATE BETWEEN NVL(rv.start_date_active, SYSDATE) AND NVL(rv.end_date_active, SYSDATE) ORDER BY rv.sequence;
• SELECT response_value_id, response_type_id, text, correct_flag FROM ota_response_values WHERE response_value_id = :p_response_value_id AND business_group_id = :p_bg_id;
• Reporting on scored assessments: join to OTA_UTEST_RESPONSES on RESPONSE_VALUE_ID to reconcile a learner's selected value against CORRECT_FLAG for grading and result analysis.

Related Objects

The documented relationships define the object's immediate neighborhood:

• OTA_RESPONSE_TYPES — parent table; OTA_RESPONSE_VALUES.RESPONSE_TYPE_ID references it. Provides the question/response-type context for every value.
• OTA_UTEST_RESPONSES — child table; its RESPONSE_VALUE_ID column references OTA_RESPONSE_VALUES, capturing the value a learner actually selected on a test.
• OTA_RESPONSE_VALUES_PK — the primary-key constraint/index on RESPONSE_VALUE_ID that guarantees uniqueness.

Together these three tables form the core of the online test and survey question-answer model in Learning Management, with OTA_RESPONSE_TYPES defining the question, OTA_RESPONSE_VALUES enumerating its options, and OTA_UTEST_RESPONSES recording learner choices against those options.