Rules Search Using Question Or Variable Criteria Causes JBO-27122 Error (Doc ID 1287001.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Procurement Contracts - Version 12.0.6 to 12.0.6 [Release 12]
Information in this document applies to any platform.
***Checked for relevance 28-Jan-2014***

Symptoms

When trying to search on a Contract Expert Rule using the Question or Variable fields, the error below occurs.


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

Error details are:
Exception Details. oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select XPRT.question_id, XPRT.question_name, XPRT.description, XPRT.question_intent, INTENT.meaning Intent_display FROM okc_xprt_questions_vl XPRT, FND_LOOKUPS INTENT WHERE question_type='Q' AND INTENT.LOOKUP_CODE=XPRT.QUESTION_INTENT AND INTENT.LOOKUP_TYPE='OKC_ARTICLE_INTENT' and exists ( select 'x' from okc_xprt_rule_cond_vals cvals, okc_xprt_rule_hdrs xrh, okc_xprt_rule_conditions cond where xrh.rule_id=cond.rule_id AND xrh.org_id=:orgId and cond.rule_condition_id=cvals.rule_condition_id and cond.object_value_type ='QUESTION' and cvals.object_value_code=to_char(xprt.question_id) UNION ALL select 'x' from okc_xprt_rule_hdrs xrh, okc_xprt_rule_conditions cond where xrh.rule_id=cond.rule_id AND xrh.org_id=:orgId and cond.object_type ='QUESTION' and cond.object_code=to_char(xprt.question_id) UNION ALL select 'x' from okc_xprt_rule_hdrs xrh, okc_xprt_rule_outcomes xro where xrh.rule_id=xro.rule_id and xrh.org_id=:orgId and xro.object_type='QUESTION' and xro.object_value_id=xprt.question_id) order by question_intent,question_name) QRSLT WHERE (( UPPER(QUESTION_NAME) like :1 AND (QUESTION_NAME like :2 OR QUESTION_NAME like :3 OR QUESTION_NAME like :4 OR QUESTION_NAME like :5))) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:896) at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169) at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1435) at

etc...

Steps to reproduce:
1. Go to (R) Contracts Term Library Administrator (N) Contracts Expert >Rules
2. Enter search terms in the question or variable field and click (B) Go
- the error occurs.

Cause

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