Create Quote in HTML Error"JBO-27122: SQL Error During Statement Preparation, java.sql.SQLException: Missing IN or OUT parameter at index:: 1"

(Doc ID 1070150.1)

Last updated on NOVEMBER 01, 2017

Applies to:

Oracle Quoting - Version 12 and later
Information in this document applies to any platform.

Symptoms

When attempting to Create a Quote in the HTML UI, the following error occurs.

Error

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.

Exception Details.

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException:
JBO-27122: SQL error during statement preparation.
Statement: SELECT * FROM
(SELECT oeab.agreement_id, oeatl.name, oeab.price_list_id,oeab.term_id , oeab.start_date_active, oeab.end_date_active, oeab.sold_to_org_id
FROM OE_AGREEMENTS_B oeab,
OE_AGREEMENTS_TL oeatl ,
(select cust_account_id org_id
FROM HZ_CUST_ACCT_RELATE b
WHERE related_cust_account_id = :2
and status = 'A' union select -1 from dual
union select :1 from dual) org_list
where oeab.agreement_id = oeatl.agreement_id
and oeatl.language = userenv('LANG')
and org_list.org_id=oeab.sold_to_org_id(+)) QRSLT ORDER BY name
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:896)
.
## Detail 0 ##
java.sql.SQLException: Missing IN or OUT parameter at index:: 1
    at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1752)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3444)
    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)

 

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

  1. Responsibility: Oracle Sales User 
  2. Navigation: Quotes
  3. Click "Create Quote" button
  4. Receive error

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