Order Release Screen Is Throwing Error When Involved Party Contact ID Added As Default Criteria. (Doc ID 2381192.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

While we are adding the Involved Party Contact ID as a default criteria on order relase screen,the following error is seen:

[022273] [SQL_STATEMENT] select o.order_release_gid, o.order_release_gid from ORDER_RELEASE o where (o.domain_name=?) and (o.order_release_gid in (select orl.order_release_gid from OB_ORDER_BASE orlob, ORDER_RELEASE_LINE orl where (orlob.order_base_gid in ()) and (orl.order_base_gid=orlob.order_base_gid))); [TPX] (250)
  java.sql.SQLSyntaxErrorException: ORA-00936: missing expression


java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:774)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:925)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1104)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4845)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1501)
at glog.util.jdbc.noserver.SqlPreparedStatement.executeQuery(SqlPreparedStatement.java:35)
at glog.util.jdbc.noserver.SqlQuery.executeQuery(SqlQuery.java:209)
at glog.util.jdbc.noserver.SqlQuery.resetArguments(SqlQuery.java:177)
at glog.util.jdbc.noserver.SqlQuery.open(SqlQuery.java:146)

Cause

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