ER: Store Question Text Of Assessment Question On User_Test_Question In Case Question Text Changes (Doc ID 1943463.1)

Last updated on DECEMBER 20, 2016

Applies to:

Oracle iLearning - Version 6.0 and later
Information in this document applies to any platform.

Goal

On reports with Question_Text and Attempt, show the Question_Text for the question at the time of the attempt and not what is current at time of report. Is this possible?

Customer has run into a situation related to Assessment Items and how they appear in reports. Customer edited an assessment question that was live and
being used in two assessment sections. Once they caught it they wanted to go back and see who had completed the correct version vs the edited, wrong version. Customer
found that reports the Question Text that appears reflects the Item that is in use in the section at the time of the report and NOT the Item that was attempted by user (if they attempted the item before the change).

This was tested this by :
Creating a test bank with one question: " Do you see blue?"
Creating and offering a test with the one question: "Do you see blue?"
Attempting the question and answering correctly "Yes"
Running any report that had question text in it.
Question_Text column the question appears, "Do you see Blue"?

Next: Edited the question text to "Do you see green?"
Ran the same report
Question_Text column appears, "Do you see green?" with same attempt ID

This appears to show that the Question_Text column pulls the Question_Text from the Test Bank as it is at the time of the report run and not as it WAS at the time of
the attempt.
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms