My Oracle Support Banner

FTI Ad Hoc Query Within The Shipment Order Release Analysis Displaying The Destination With The Same Value as The Source (Doc ID 2120382.1)

Last updated on MARCH 25, 2016

Applies to:

Oracle Fusion Transportation Intelligence - Version 6.3.2 to 6.4.1 [Release 6.3 to 6.4]
Information in this document applies to any platform.


Completing an Ad Hoc Query within FTI on Shipment Order Release Analysis for the Shipment Order Release Source Geography Dimensions and the Shipment Order Release Destination Dimensions, returns a result that displays the Source & Destination Information with the same value.

The above issue is present when completing the following:

Navigate: FTI / Ad Hoc Query / Advanced Tab/ Transportation Intelligence 

1. Build a query under the Criteria Tab using the 
Shipment Order Release Analysis with the selections --- FTI Order Release GID -- Destination Geography Dimensions"."Location GID" --- Source Geography Dimensions"."Location GID"

2. Click the Results Tab to Execute the Query

The results returned with this query displays the Destination Location Gid and The Source Location Gid  showing the same values 
For Example Order Release called ABCD was returned by the query will display the Source as Seattle and the Destination as Seattle

3. Proceed to Open the Order Release by Navigating to Order Management>Order Release>Order Release search for Order Release ABCD
Once Located Reviewed that the Source Location is Seattle and the Destination Location is Orlando


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.