Running An Riq Using The 'Date Deliver By', Is Not Fetching Results

(Doc ID 751317.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version: 5.5.04
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.


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