Record Not Found Error Received WhenFill Shipment Set Distance Action With External Distance Engine in Public Domain (Doc ID 1289321.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Sourcing - Version: 6.1.0 to 6.1.5 - Release: 6.1 to 6.1
Information in this document applies to any platform.

Symptoms


When the distance is null on the shipments attached to a shipment set and a Rate Distance from the local domain is used to Fill Shipment Set Distance, the following error is received:

ejb.RateDistance record not found: pk=PCMILER_DEFAULT_POSTAL_POSTAL

It appears that the logic is expecting the record to be in the Public domain and not the local. You can choose any of the entries from the Public Domain and the error is not received. Also note if the distance on the shipments are not currently null, the error also does not happen.


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

1. Log into OTM 6.1.
2. Go to Sourcing --> Historical Shipments --> Shipment Set Criteria.
3. Search for a shipment set which has shipments attached with a null distance.
4. Select and go to Actions --> Fill Shipment Set Distance.
5. Click the "l" under Rate Disstance ID and a rate distance in the local
domain.
6. Click "Fill Shipment Set Distance".
7. Note the Error: ejb.RateDistance record not found:
pk=PCMILER_DEFAULT_POSTAL_POSTAL

The full stack trace:

Could not retrieve RATE_DISTANCE(s)
weblogic.rjvm.ResponseImpl.unmarshalReturn(ResponseImpl.java:234)
weblogic.rmi.cluster.ClusterableRemoteRef.invoke(ClusterableRemoteRef.java:348 )
weblogic.rmi.cluster.ClusterableRemoteRef.invoke(ClusterableRemoteRef.java:259 )
glog.procurement.app.business.util.DBUtilSessionHome_7v0s8f_EOImpl_1031_WLStub
.fillShipmentSetDistance(Unknown Source)
glog.procurement.util.DBAction.fillShipmentSetDistance(DBAction.java:904)
glog.procurement.web.servlet.ActionServlet.doAction(ActionServlet.java:425)
glog.procurement.web.servlet.ActionServlet.process(ActionServlet.java:896)
glog.webserver.util.BaseServlet.service(BaseServlet.java:705)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFi
lterChain.java:290)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChai
n.java:206)
glog.webserver.session.ParameterValidation.doFilter(ParameterValidation.java:2
9)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFi
lterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChai
n.java:206)
glog.webserver.screenlayout.ClientSessionTracker.doFilter(ClientSessionTracker
.java:59)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFi
lterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChai
n.java:206)
glog.webserver.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFi
lter.java:44)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFi
lterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChai
n.java:206)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java
:233)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java
:191)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:1
09) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767)
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697)
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:8
89) org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:
690) java.lang.Thread.run(Thread.java:619)

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