My Oracle Support Banner

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

Last updated on AUGUST 29, 2020

Applies to:

Oracle Time and Labor - Version 12.2.8 and later
Information in this document applies to any platform.

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

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
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.