Getting Java error when Saving Quote After Pricing Quote (Doc ID 1314098.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms



Following error is encountered while trying to save a quote using HTML UI

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT
lookup_code,
meaning,
view_application_id,
lookup_type
FROM
fnd_lookup_values
WHERE
trunc(nvl(start_date_active, sysdate)) <= trunc(sysdate) AND
trunc(nvl(end_date_active, sysdate)) >= trunc(sysdate) AND
enabled_flag = 'Y' AND
language = USERENV('LANG') AND
lookup_type = :1 AND
view_application_id = :2) QRSLT ORDER BY meaning
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)
...

java.sql.SQLException: Missing IN or OUT parameter at index:: 1
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1783)

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