My Oracle Support Banner

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

Last updated on MAY 06, 2022

Applies to:

Oracle Transportation Management - Version 6.4.1 and later
Information in this document applies to any platform.


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(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4C8Oall.processError(
at oracle.jdbc.driver.T4CTTIfun.receive(
at oracle.jdbc.driver.T4CTTIfun.doRPC(
at oracle.jdbc.driver.T4C8Oall.doOALL(
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(
at glog.util.jdbc.noserver.SqlPreparedStatement.executeQuery(
at glog.util.jdbc.noserver.SqlQuery.executeQuery(
at glog.util.jdbc.noserver.SqlQuery.resetArguments(


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

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