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 JULY 20, 2024

Applies to:

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

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