Network Leg With Calculate Contracted Rate / Calculate Service Time Disabled Causes Planning Failure (Doc ID 1903784.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Transportation Operational Planning - Version 6.3.2 to 6.3.5 [Release 6.3]
Information in this document applies to any platform.

Symptoms

When planning an order release having a network configuration of three legs and having Calculate Contracted Rate and Calculate Service Time disabled on the second or on the third network leg, using instead expected service time, the planning fails with the following log error:

ERROR
-----------------------
Error Exception Rate service PK is null, can not calculate rate service
Rate service PK is null, can not calculate rate service

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Configure the network routing itinerary having three network legs
2. On the second network leg disable Calculate Contracted Rate and Calculate Service Time
3. On the same leg add the expected service time of 12 hours
4. Plan an order on the above itinerary and this will fail with the following error message:

Error Exception Rate service PK is null, can not calculate rate service
Rate service PK is null, can not calculate rate service

at sun.reflect.GeneratedConstructorAccessor884.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at glog.util.exception.GLException.factory(GLException.java:460)
at glog.util.exception.GLException.factory(GLException.java:436)
at glog.util.exception.GLException.factory(GLException.java:432)
at glog.util.exception.GLException.factory(GLException.java:428)
at glog.business.rateservicescheduling.TRateService.getInstance(TRateService.java:114)
at glog.business.rateservicescheduling.RateServiceHelper.estimateTimeWindowForLastStop(RateServiceHelper.java:815)
at glog.business.rateservicescheduling.RateServiceHelper.estimateOtherStopTimeWindow(RateServiceHelper.java:666)
at glog.business.rateservicescheduling.RateServiceEngine.drive(RateServiceEngine.java:112)
at glog.business.networkrouting.rateinquiry.RateInquirer.retrieveTransitTime(RateInquirer.java:641)
at glog.business.networkrouting.rateinquiry.RateInquirer.getTransitTime(RateInquirer.java:620)
at glog.business.util.PlanningUtils.getTransitTime(PlanningUtils.java:82)
at glog.business.util.PlanningUtils.getTransitTime(PlanningUtils.java:62)
at glog.business.networkrouting.OrderRouter.computeTransitTime(OrderRouter.java:490)
at glog.business.networkrouting.OrderRouter.computeSourceTransitTimes(OrderRouter.java:443)
at glog.business.networkrouting.OrderRouter.computeTransitTime(OrderRouter.java:413)
at glog.business.networkrouting.OrderRouter.prepareNROrderAndNetworkForSolver(OrderRouter.java:348)
at glog.business.networkrouting.OrderRouter.routeOrders(OrderRouter.java:207)
at glog.business.networkrouting.NetworkRoutingPlanner.routeOrderReleases(NetworkRoutingPlanner.java:285)
at glog.business.networkrouting.NetworkRoutingPlanner.planOrderReleases(NetworkRoutingPlanner.java:112)
at glog.business.consolidation.bulkplan.NetworkRoutingOrderPlanner.bulkPlanOrderReleases(NetworkRoutingOrderPlanner.java:157)
at glog.business.action.order.BulkPlanActionExecutor.planOrders(BulkPlanActionExecutor.java:139)
at glog.business.session.OrderActionSessionBean.planOrders(OrderActionSessionBean.java:1339)
at glog.business.session.OrderActionSessionServerSideEJBWrapper.planOrders(OrderActionSessionServerSideEJBWrapper.java:1305)
at glog.business.session.OrderActionSessionHome_likuwd_EOImpl.__WL_invoke(Unknown Source)
at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:40)
at glog.business.session.OrderActionSessionHome_likuwd_EOImpl.planOrders(Unknown Source)
at glog.server.workflow.adhoc.BulkPlan.executeOrder(BulkPlan.java:70)
at glog.server.workflow.adhoc.BulkPlan.execute(BulkPlan.java:54)
at glog.server.workflow.SimpleWorkflow.execute(SimpleWorkflow.java:23)
at glog.server.workflow.WorkflowSessionBean.execute(WorkflowSessionBean.java:64)
at glog.server.workflow.WorkflowSessionNonTransServerSideEJBWrapper.execute(WorkflowSessionNonTransServerSideEJBWrapper.java:40)
at glog.server.workflow.WorkflowSessionNonTransServerSideEJBWrapper_t6tuwu_EOImpl.__WL_invoke(Unknown Source)
at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:40)
at glog.server.workflow.WorkflowSessionNonTransServerSideEJBWrapper_t6tuwu_EOImpl.execute(Unknown Source)
at glog.server.workflow.WorkflowManager.execute(WorkflowManager.java:352)
at glog.server.workflow.Trigger.trigger(Trigger.java:122)
at glog.util.event.MemoryEventQueueRunnable.processEvent(MemoryEventQueueRunnable.java:145)
at glog.util.event.MemoryEventQueueRunnable.run(MemoryEventQueueRunnable.java:100)
at glog.util.event.EventThread.run(EventThread.java:86)
at java.lang.Thread.run(Thread.java:662)
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot have the business requirement that is needed in this configuration

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