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 MAY 06, 2022
Applies to:Oracle Transportation Management - Version 5.5.05.04 and later
Information in this document applies to any platform.
-- Problem Statement:
On 5.5.05.04 when attempting to merge two shipments using Continuous Moves 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 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.
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