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 JULY 06, 2020

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 and the Destination as the same value.

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 different than Destination Location.




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.