My Oracle Support Banner

Departure Date Of Voyage Is Not Updated In Search Results (Doc ID 948137.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.


-- Problem Statement:
When manually creating a voyage via the UI and populating departure/arrival dates/times for the
stops, the field DEP_DATE on the VOYAGE table is automatically populated with the departure date
from the VOYLOC table.

The VOYAGE departure date is not updated when the VOYLOC departure date is chaged.

As a result, when searching for a voyage the field departure date represents the DEP_DATE field rather than the first departure date on the stop details (voyage locations). If this is different, the voyage is not returned in the search results.

A similar effect happens, when using CSV files to upload data with a different DEP_DATE from the first
departure date from the VOYLOC table, or leaving it blank so that the system uses the sysdate.
Once the DEP_DATE is populated - it cannot be edited via the UI and any update to the dates for
the stop locations is also not reflected.


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.