My Oracle Support Banner

After Upgrade To Oracle 12.2.9 In Quality Parent Child Result Inquiry From Error Occurred (Doc ID 2802342.1)

Last updated on AUGUST 31, 2021

Applies to:

Oracle Quality - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.9 version, SUPPORT

When attempting to open the Quality parent child result inquiry after upgrade to 12.2.9 the following error occurs.

ERROR
-----------------------
Error Page
Exception Details.
 oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT QA_SS_PARENT_CHILD_PKG.GET_PLAN_VQR_SQL ( :1 , :2 , :3 , :4 ) AS VQR_SQL_STMT
FROM DUAL
at oracle.jbo.server.BaseSQLBuilderImpl.processException(BaseSQLBuilderImpl.java:3383)
at oracle.jbo.server.OracleSQLBuilderImpl.processException(OracleSQLBuilderImpl.java:4022)
at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:961)
at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Resp: Oracle Quality
2. Navigate to parent child result inquiry
3. Get the above error

Cause

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
Symptoms
Cause
Solution


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