My Oracle Support Banner

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

Last updated on MARCH 11, 2019

Applies to:

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

Symptoms

Error saving 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)

Changes

 

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
Changes
Cause
Solution
References


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