Unable to Create Shipment Group Fails (Doc ID 459154.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Transportation Management - Version 5.5.03 and later
Information in this document applies to any platform.
***Checked for relevance on 25-Oct-2010***


Symptoms

-- Problem Statement:
While trying to create a shipment group, following exception is encountered and no shipment group is created.

1. Navigate to Transportation Planning and Execution -> Shipment Management Buy Shipments
2. Go to Order Release tab and enter OR ID: SHIP_GROUP and search.
3. Actions -> Manage Groups and Charges -> Create Shipment Group
4. Select Type = Exporter and Source = Destination = PHL, then Finished

2007-09-13 10:41:00.779 0 Error Exception select con.contact_gid, con.location_gid,
con.contact_gid, con.contact_xid from CONTACT con where (con.is_primary_contact='Y') and
(con.location_gid in ()) [ExecuteThread: '21' for q]
2007-09-13 10:41:00.780 0 Debug Sql {call vpd.set_user_r(?,?,?,?)}; inParams=[TMS.ADMIN,
ADMIN, null, STATIC] [ExecuteThread: '21' for q]
2007-09-13 10:41:00.782 0 Debug Sql select error_translation_gid, solution_translation_gid
from oracle_error where error_code=? and constraint_id=? /* DEFAULT */; [936, NULL]
[ExecuteThread: '21' for q]
2007-09-13 10:41:00.799 0 Error Exception java.sql.SQLException: ORA-00936: missing expression


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

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:589)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1957)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:888)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2555)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2896)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:644)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:570)
at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:124)
at glog.util.jdbc.noserver.SqlQuery.executeQuery(SqlQuery.java:138)
at glog.util.jdbc.noserver.SqlQuery.open(SqlQuery.java:82)
at glog.server.query.JDBCFinder.query(JDBCFinder.java:424)
at glog.server.query.JDBCFinder.open(JDBCFinder.java:147)
at glog.server.query.ListRetrieverBean.retrieve(ListRetrieverBean.java:39)
at
glog.server.query.query_ListRetriever_whmeh3_EOImpl.retrieve(query_ListRetriever_whmeh3_EOImpl.java:
46)
at
glog.server.query.query_ListRetriever_whmeh3_EOImpl_WLSkel.invoke(ILweblogic.rmi.spi.InboundRequest;
Lweblogic.rmi.spi.OutboundResponse;Ljava.lang.Object;)Lweblogic.rmi.spi.OutboundResponse;(Unknown
Source)
at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:477)
at weblogic.rmi.cluster.ReplicaAwareServerRef.invoke(ReplicaAwareServerRef.java:112)
at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:420)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:147)
at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:369)
at weblogic.rmi.internal.BasicExecuteRequest.execute(BasicExecuteRequest.java:30)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:219)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:178)
[ExecuteThread: '21' for q]

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms