Update a unpublished questionnaire with Answer Type as List Of Values (LOV) throws Unexpected java Exception / Error "JBO-27022: Failed to load value at index 5 with java object" (Doc ID 2771525.1)

Last updated on SEPTEMBER 09, 2024

Applies to:

Symptoms

When you try to add more than 2 Answer Type as List Of Values (LOV) to a non published questionnaire

or

When attempting to update a non published questionnaire which has 2 or more questions with Answer Type as List Of Values (LOV) associated to it,

then the following error occurs.

ERROR
-----------------------

You have encountered an unexpected error. Please contact the System Administrator for assistance.
Click here for exception details.

Exception Log:
------------------------

oracle.apps.fnd.framework.OAException: oracle.jbo.AttributeLoadException: JBO-27022: Failed to load value at index 5 with java object of type java.lang.String due to java.sql.SQLException

STEPS
-----------------------

The issue can be reproduced at will with the following steps:

1. Responsibility: HR Professional V4.0

2. Navigation: Questionnaire Administration - New –> Create Questionnaire

3. Enter a name for the questionnaire and save.

4. Now go back to Questionnaire Administration and try to update the Questionnaire that was created in step 3.
   
5. Now in the launched page, to the Questionnaire opened, try to add questions with Answer type as List Of Values (LOV).

6. After adding 2 questions with Answer Type as List Of Values (LOV), When you try to add the third question of the same Answer Type, then the Error reported above is thrown.

7. When you open the exception log using the "click here" link in the error message, above exception message is seen.

8. Same issue happens when you click on "Update" icon against a non published questionnaire which has 2 or more questions with Answer Type as List Of Values (LOV) associated to it.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.