My Oracle Support Banner

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

Last updated on MAY 06, 2022

Applies to:

Oracle Transportation Sourcing - Version 6.1.0 to 6.1.5 [Release 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 Distance 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(ApplicationFilterChain.java:290)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
glog.webserver.session.ParameterValidation.doFilter(ParameterValidation.java:29)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
glog.webserver.screenlayout.ClientSessionTracker.doFilter(ClientSessionTracker.java:59)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
glog.webserver.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:44)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.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:889)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690) java.lang.Thread.run(Thread.java:619)

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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