My Oracle Support Banner

'Java.sql.SQLException: Invalid Column Index' Or 'Missing Right Parenthesis' Error When Searching Work Order Description With Single Quote (Doc ID 2642065.1)

Last updated on MARCH 04, 2020

Applies to:

Oracle Enterprise Asset Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to search WO,
the following error occurs.

ERROR
-----------------------
 You have encountered an unexpected error. Please contact the System Administrator for assistance. Click here for exception details.

Java Exception Details:

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT wdj.WIP_ENTITY_ID,
  wdj.DESCRIPTION,
  wdj.STATUS_TYPE,
...
...
  AND wdj.maintenance_object_source <> 2) QRSLT WHERE (wdj_organization_id = :3 AND( (( ( (UPPER(instance_number) = :4 )
  AND (instance_number LIKE :5 OR instance_number LIKE :6 OR instance_number LIKE :7 OR instance_number LIKE :8 )) ) )
  AND upper(DESCRIPTION) = upper('LABOUR FOR PUMP CENTRAL'S FACTORY') AND (scheduled_start_date > :9 ) ))
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1183)
...
...
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:745)
## Detail 0 ##
java.sql.SQLException: Invalid column index
at oracle.jdbc.driver.OraclePreparedStatement.setTimestampInternal(OraclePreparedStatement.java:7104)
at oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:8418)
...
...
at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:879)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:745)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Maintenance Super User.
2. Home->Work Orders
3. Click on Advanced Search.
4. Query for an Work Order with description LABOUR FOR PUMP CENTRAL'S FACTORY
5. Click on GO.


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.