My Oracle Support Banner

5.5 OTM Rate Inquiry Using The 'Date Deliver By' Does Not Work (Doc ID 789557.1)

Last updated on MAY 06, 2022

Applies to:

Oracle Transportation Management - Version 5.5.04 and later
Information in this document applies to any platform.
This problem can occur on any platform.


When running an RIQ with the 'Date Deliver By' as November 30, we have a 'Voyage Schedule' for the Ocean Primary leg till 28 Dec, and have attached this Voyage Schedule to the Rate Service .

When we run the RIQ with the above date, the system inserts the 'Date Available By' as the current date and gives the immediate next available schedule instead of the schedule which will meet 'Date Deliver By' of Nov 30'.  If we run the same query with the date available by as 5th Nov, it is fetching the right rate and schedule.

After changing the Parameter to 'HOLD AS LATE AS POSSIBLE' to 'TRUE' and when run RIQ which has a Voyage Schedule, it gives "No Routes and Rates found" and does not fetch any Rate and Route.  But the same works fine using Rate Service as 'Look Up' without any schedules attached.


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

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