My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Transportation Management - Version: 5.5.04
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 08', 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'08 , it is fetching the right rate and schedule.

After changing the Paramater to 'HOLD AS LATE AS POSSIBLE' to 'TRUE' and when run RIQ which has a Voyage Schedule, it gives as "No Routes and Rates found" and does not fetch any Rate and Route,
but the same works fine if I have my Rate Service as just '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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

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