Transmission Error While Uploading The 'Shipment Group' XML (Doc ID 729979.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version: 5.5.04 to 5.5.04.03
This problem can occur on any platform.

Symptoms

-- Problem Statement:

Uploading a Shipment Group XML with more than one RefNumQual is causing incorrect SQL to be called.  The SQL is looking for the column 'ship_group_refnum_qual_gid' in the 'shipment_refnum_qual' table when that column does not exist in that table.

The entry in the log is as follows:

select update_flag from shipment_refnum_qual
where ship_group_refnum_qual_gid = ? /* DEFAULT */; [XXX.CUSTOMER REFERENCE]

The Stack Trace shown is as follows:

CAUGHT THE FOLLOWING EXCEPTION WHILE PROCESSING TRANSACTION: java.sql.SQLException:
ORA-00904: "SHIP_GROUP_REFNUM_QUAL_GID": invalid identifier java.sql.SQLException:
ORA-00904: "SHIP_GROUP_REFNUM_QUAL_GID": invalid identifier at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at
oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:486) at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216) at
oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe
(T4CPreparedStatement.java:844) at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe
(T4CPreparedStatement.java:850) at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1134)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal
(OraclePreparedStatement.java:3339) at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery
(OraclePreparedStatement.java:3384) at
weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:124) at
glog.util.jdbc.noserver.SqlQuery.executeQuery(SqlQuery.java:146) at
glog.util.jdbc.noserver.SqlQuery.resetArguments(SqlQuery.java:124) at
glog.util.jdbc.noserver.SqlQuery.open(SqlQuery.java:99) at
glog.integration.xmlbasewrapper.RefnumHandler.getUpdateFlag(RefnumHandler.java:196)
at glog.integration.xmlbasewrapper.RefnumHandler.validateRefnum
(RefnumHandler.java:167) at glog.integration.xmlbasewrapper.RefnumHandler.process
(RefnumHandler.java:122) at
glog.integration.xmlbasewrapper.RefnumBaseWrapperList.getContainerList
(RefnumBaseWrapperList.java:42) at
glog.integration.application.shipmentgroup.ShipmentGroupHeaderWrapper.mapChildren
(ShipmentGroupHeaderWrapper.java:227) at
glog.integration.xmlbasewrapper.XmlBaseWrapper.map(XmlBaseWrapper.java:165) at
glog.integration.application.shipmentgroup.ShipmentGroupWrapper.mapSelf
(ShipmentGroupWrapper.java:116) at
glog.integration.xmlbasewrapper.XmlBaseWrapper.map(XmlBaseWrapper.java:163) at
glog.integration.xmlbasewrapper.XmlBaseWrapper.persistViaContainer
(XmlBaseWrapper.java:274) at
glog.integration.application.shipmentgroup.ShipmentGroupWrapper.persistViaContainer
(ShipmentGroupWrapper.java:184) at
glog.integration.application.shipmentgroup.ShipGroupTransControlSessionBean.persistX
ML(ShipGroupTransControlSessionBean.java:42) at
glog.integration.application.shipmentgroup.ShipGroupTransControlSessionServerSideEJB
Wrapper.persistXML(ShipGroupTransControlSessionServerSideEJBWrapper.java:36) at
glog.integration.application.shipmentgroup.ShipGroupTransControlSessionServerSideEJB
Wrapper_qozlsl_EOImpl.persistXML
(ShipGroupTransControlSessionServerSideEJBWrapper_qozlsl_EOImpl.java:46) at
glog.integration.application.shipmentgroup.ShipmentGroupInterface.persistXMLThroughB
ean(ShipmentGroupInterface.java:95) at
glog.integration.application.shipmentgroup.ShipmentGroupInterface.persistXML
(ShipmentGroupInterface.java:81) at
glog.integration.application.BaseInterface.persistXMLBase(BaseInterface.java:185) at
glog.integration.application.TransactionProcessor.processTransaction
(TransactionProcessor.java:210) at
glog.integration.application.TransactionProcessor.processTransaction
(TransactionProcessor.java:349) at glog.server.workflow.transproc.TransProc.execute
(TransProc.java:94) at glog.server.workflow.SimpleWorkflow.execute
(SimpleWorkflow.java:23) at glog.server.workflow.WorkflowSessionBean.execute
(WorkflowSessionBean.java:64)</IMessageText>



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