Results for “feedback_type_flag”

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

Overview

OTA_UTEST_QUESTIONS_V is an APPS-owned, VALID view within the OTA (Learning Management) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It presents the fully resolved result set of a learner's attempt at an online test, joining question-level attempt records to their corresponding responses, feedback text, and scoring attributes. The view is exposed for reporting and integration purposes, allowing external tools, BI Publisher reports, and Oracle Discoverer worksheets to retrieve test question outcomes without reconstructing the multi-table join manually.

Because the view surfaces POINTS_AWARDED and SUGGESTED_POINTS alongside correctness and feedback flags, it is particularly relevant to scoring analysis and certification audit. The user search term "points_awarded" maps directly to a column in this view, confirming its role in point-based scoring and assessment reporting.

Underlying Base Objects

The view is defined over the following documented APPS synonyms: OTA_QUESTIONS, OTA_RESPONSE_TYPES, OTA_RESPONSE_VALUES, OTA_TESTS, OTA_TEST_SECTIONS, OTA_UTEST_QUESTIONS, and OTA_UTEST_RESPONSES. The core join links attempt question rows (OTA_UTEST_QUESTIONS, aliased UTQ) to learner responses (OTA_UTEST_RESPONSES, UTR) via USER_TEST_QUESTION_ID. Response metadata is enriched through OTA_RESPONSE_TYPES (feedback and correctness flags) and OTA_RESPONSE_VALUES (correct/incorrect answer text). The question master is obtained from OTA_QUESTIONS (Q.TEXT, ALLOW_HTML_FLAG).

A nested inline subquery joins OTA_UTEST_QUESTIONS, OTA_TEST_SECTIONS, and OTA_TESTS on OBJECT_TYPE_FLAG = 'S' to derive section-level and test-level feedback, names, descriptions, and the mandatory flag. The outer query then links each question (OBJECT_TYPE_FLAG = 'Q') to its parent section row via UTQ.PARENT_ID = UTSEC.USER_TEST_QUESTION_ID.

Key Columns

• USER_TEST_QUESTION_ID / USER_TEST_RESPONSE_ID / ATTEMPT_ID — identity and attempt context for the question and its response.
• POINTS_AWARDED — points actually credited to the learner for the question, central to scoring analysis.
• QUESTION_SUGGESTED_POINTS (SUGGESTED_POINTS) — maximum points defined for the question.
• CORRECT_FLAG, SKIPPED_FLAG, ANSWERED_FLAG, MARKED_FOR_REVIEW_FLAG — outcome and review state indicators.
• RESPONSE_TYPE, RESPONSE_TYPE_ID, RESPONSE_VALUE_ID, USER_RESPONSE_TEXT — the learner's selected answer and its type metadata.
• CORRECT_FEEDBACK, WRONG_FEEDBACK, SECTION_*, TEST_* — feedback text resolved at response, section, and test levels.
• QUESTION_ID, PARENT_ID, SECTION_ID, SECTION_NAME, MANDATORY_FLAG — structural linkage of question to section and test.

Common Use Cases and Queries

The view is typically queried to report per-question scores, identify questions where awarded points differ from suggested points, and audit learner responses against correct feedback. A representative query retrieving awards for a given attempt:

SELECT USER_TEST_QUESTION_ID, QUESTION_ID,
       POINTS_AWARDED, QUESTION_SUGGESTED_POINTS,
       CORRECT_FLAG, SKIPPED_FLAG, SECTION_NAME
FROM   APPS.OTA_UTEST_QUESTIONS_V
WHERE  ATTEMPT_ID = :p_attempt_id
ORDER BY USER_TEST_QUESTION_ID;

For scoring variance analysis across test sections, aggregate POINTS_AWARDED and compare with SUGGESTED_POINTS grouped by SECTION_NAME. Because the view is APPS-owned, queries should be run with APPS or a synonym-granted reporting schema, and joins to attempt or enrollment headers should be performed through ATTEMPT_ID.