Results for “ota_response_types”

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

Overview

OTA_RESPONSE_TYPES is a table in the OTA (Learning Management / Oracle Training Administration) schema that stores the response-side configuration of questions used throughout the Oracle E-Business Suite online assessment and certification infrastructure. Where OTA_QUESTIONS captures the question stem and its identifying attributes, OTA_RESPONSE_TYPES holds the additional detail that governs how a learner's answer is presented, scored, and evaluated. The table is documented as having a current 1:1 relationship with OTA_QUESTIONS, while the underlying data model was intentionally designed to permit hybrid question types — that is, a single logical question that combines multiple presentation or grading behaviors. This forward-compatible design explains why response-type data is factored into its own entity rather than being merged into the question record.

Under the heuristic Data Vault classification mined from the foreign-key structure, OTA_RESPONSE_TYPES is hub-leaning. In modeling terms, this suggests the table is best understood as a durable, business-keyed entity of its own rather than as a pure junction (link) or a descriptive attribute set (satellite). Its identity is stable, its descriptive columns drift slowly, and it serves as a reference point that other transactional tables hang off of.

Key Information Stored

The table is documented with 14 physical columns. The most significant are summarized below.

• RESPONSE_TYPE_ID — the surrogate primary key, enforced by the unique index OTA_RESPONSE_TYPES_PK. This is the column commonly referenced in the EBS user's search term "response_type_id" and is the value carried as a foreign key by dependent tables.
• QUESTION_ID — foreign key to OTA_QUESTIONS, establishing the owning question for each response-type definition. In the documented 1:1 model this column effectively acts as a business-key candidate alongside the primary key.
• BUSINESS_GROUP_ID — the multi-tenant discriminator, indicating that response types are partitioned by business group in the standard OTA/HRMS security model.
• TYPE_FLAG — indicates the response type (for example multiple-choice, free-text, or another graded format), driving how the response is rendered and evaluated.
• SUGGESTED_POINTS — the point value proposed for the question or response, used in scoring calculations.
• DISPLAY_ORDER_FLAG — controls whether and how the associated answer options are ordered when presented to the learner.
• CORRECT_FEEDBACK and WRONG_FEEDBACK — the feedback text shown to a learner after a correct or incorrect response, respectively.
• OBJECT_VERSION_NUMBER — the optimistic-locking column used by the OAF/ADF framework to detect concurrent updates.
• CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard EBS WHO columns providing audit and accountability tracking.

Common Use Cases and Queries

Typical reporting and integration scenarios include retrieving the response configuration for a given question, joining response types to their possible answers, or analyzing scoring points per question. A common query resolves a question to its response type:

• SELECT q.question_id, r.response_type_id, r.type_flag, r.suggested_points FROM ota_questions q, ota_response_types r WHERE q.question_id = r.question_id AND q.question_id = :question_id;
• Enumerating the answer options for a response type by joining OTA_RESPONSE_VALUES on RESPONSE_TYPE_ID.
• Auditing scoring distribution across a certification or assessment using SUGGESTED_POINTS grouped by TYPE_FLAG.
• Identifying learner responses tied to a response type via OTA_UTEST_RESPONSES for test-result analysis.

Related Objects

The foreign-key and primary-key relationship data identifies the following as the most significant related objects:

• OTA_QUESTIONS — the parent question table; joined via OTA_RESPONSE_TYPES.QUESTION_ID = OTA_QUESTIONS.QUESTION_ID.
• OTA_RESPONSE_VALUES — child table holding selectable answers; references OTA_RESPONSE_TYPES via RESPONSE_VALUES.RESPONSE_TYPE_ID.
• OTA_UTEST_RESPONSES — child table recording learner answers; references OTA_RESPONSE_TYPES via UTEST_RESPONSES.RESPONSE_TYPE_ID.

These three tables, together with the response-type hub itself, form the practical core of the OTA assessment data model and should be the focus of any query or integration touching RESPONSE_TYPE_ID.