My Oracle Support Banner

Running An Riq Using The 'Date Deliver By', Is Not Fetching Results (Doc ID 751317.1)

Last updated on JULY 20, 2024

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 attempting to run an RIQ with the 'Date Deliver By' as November 30, I 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 I 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.

If I now change the planning parameter to DEFAULT where the 'HOLD AS LATE AS POSSIBLE' to

'FALSE',and run the RIQ which has the Voyage Schedule,it is fetching the rates.


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.