When trying to create a Continuous Move the following error is seen: ejb.CmRule records not found: sql=select r.rate_offering_gid, r.x_lane_gid from cm_rule r, lane l, geo_hierarchy ghd, geo_hierarchy (Doc ID 949138.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Transportation Management - Version 5.5.05.04 and later
Information in this document applies to any platform.
***Checked for relevance on 01-Aug-2011***


Symptoms

-- Problem Statement:
On 5.5.05.04 when attempting to merge two shipments using Continuous Moves the following error is seen:


ERROR
ejb.CmRule records not found: sql=select r.rate_offering_gid, r.x_lane_gid from cm_rule r, lane l, geo_hierarchy ghd, geo_hierarchy ghs, hname_set_member hsms, hname_set_member hsmd where hsms.hname in

-- Steps To Reproduce:

1 - Create a Rate offering.
2 - Create Rate Records so that the Shipments can be planned.  Ensure the CM Rule tab is populated with lanes to cover the shipments that will be built and later placed together.
3 - Build two Shipments where the first ends close to where the second starts.
4 - Select the first shipment and select: Actions > Manage Continuous Moves > Find Shipments Max Duration of 2 days, Max Distance of 200 miles and Look Next
5 - The error message is displayed.

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