Collection Element Having Dependent Value Set From Form is Not Loading In QA_RESULTS Table (Doc ID 601587.1)

Last updated on OCTOBER 28, 2016

Applies to:

Oracle Quality - Version 11.5.9 to 12.0.4 [Release 11.5 to 12]
Oracle Quality - Version 11.5.10.2 and later
Information in this document applies to any platform.
***Checked for relevance on 22-DEC-2013***

Goal

Why data cannot be load into qa_results table (quality results) through collection import for the collection element having dependent value (Dependent LOV - list of values) which is set at form level OR being assigned by actions (having :Q_RES.XXXXX parameters references)?

Same issue in QA Workbench too, getting the following java exception pattern:

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT CODE, DESCRIPTION FROM
.............................................................................

(here at least one ":Q_RES.DISPLAY" will be mentioned)

QRSLT WHERE
.............................................................................
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891
.............................................................................
## Detail 0 ##
java.sql.SQLException: ORA-01008: not all variables bound

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

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