Collection Element Having Dependent Value Set From Form is Not Loading In QA_RESULTS Table
(Doc ID 601587.1)
Last updated on AUGUST 26, 2023
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.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |