OTL "CustomLov1VO" Throws Java.sql.SQLException: Missing IN Or OUT Parameter At Index:: 1 (Doc ID 2573989.1)

Last updated on MAY 04, 2023

Applies to:

Symptoms

OTL Timecard CustomLov1VO raises exception while click on "Go" button

ERROR
-----------------------
Exception Details.
 oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select lov1column1,
  lov1column2,
  lov1column3,
  lov1column4,
  lov1column5,
  lov1column6,
  lov1column7,
  lov1column8,
  lov1column9,
  lov1column10
from hxc_cui_custom_lov1_v
where aliasdefinitionid = :1
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1232)
.....
-----
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
## Detail 0 ##
java.sql.SQLException: Missing IN or OUT parameter at index:: 1
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1899)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3764)

Cause

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