FTI Shipment And Order Release Analysis Ad Hoc Reports Display Incorrect Reference Numbers (Doc ID 2143052.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
A Shipment Analysis report is being built within Fusion Transportation Intelligence with the following columns specified to be displayed:
"- Shipment Dimensions"."FTI Shipment GID”
"- Shipment Dimensions"."Shipment Reference Number Qualifier GID"
"- Shipment Dimensions"."Shipment Reference Number Qualifier XID"
"- Shipment Dimensions"."Shipment Reference Number Qualifier Description"
"- Shipment Dimensions"."Shipment Reference Number Value"

The report is being filtered on a specific Shipment GID, however the results of the report also show Shipment Reference Number Values that belong to other Shipment GIDs as the respective filtered Shipment GID.

The same issue is observed with Order Release reports. A Order Release Analysis report is being built within Fusion Transportation Intelligence with the following columns specified to be displayed:
"- Order Release Dimensions"."FTI Order Release GID”
"- Order Release Dimensions"."Order Release Reference Number Qualifier GID"
"- Order Release Dimensions"."Order Release Reference Number Qualifier XID"
"- Order Release Dimensions"."Order Release Reference Number Qualifier Description"
"- Order Release Dimensions"."Order Release Reference Number Value"

The report is being filtered on a specific Order Release GID, however the results of the report also show Order Release Reference Number Values that belong to other Order Release GIDs as the respective filtered Order Release GID.


EXPECTED BEHAVIOR
-----------------------
It is expected that the shipment report only show the Shipment Reference Number values of the respective Shipment GID that has been filtered on and not show any other values that are not tied to that Shipment GID. It is also expected that the order release report only show the Order Release Reference Number values of the respective Order Release GID that has been filtered on and not show any other values that are not tied to that Order Release GID.


STEPS
-----------------------
The issue can be reproduced with the following steps:

1. Navigate to Transportation Intelligence -> Ad Hoc Query -> Analysis and Interactive Reporting -> Analysis -> Transportation Intelligence
2. Select Shipment Analysis -> Shipment Dimensions.
3. Add the following columns to the report:
"- Shipment Dimensions"."FTI Shipment GID”
"- Shipment Dimensions"."Shipment Reference Number Qualifier GID"
"- Shipment Dimensions"."Shipment Reference Number Qualifier XID"
"- Shipment Dimensions"."Shipment Reference Number Qualifier Description"
"- Shipment Dimensions"."Shipment Reference Number Value"
4. Add a filter that selects a specific Shipment GID.
5. Under the results tab, the report shows Shipment Reference Number Values that belong to other Shipment GIDs as the respective filtered Shipment GID

For Order Release Analysis report:
1. Navigate to Transportation Intelligence -> Ad Hoc Query -> Analysis and Interactive Reporting -> Analysis -> Transportation Intelligence
2. Select Order Release Analysis -> Order Release Dimensions.
3. Add the following columns to the report:
"- Order Release Dimensions"."FTI Order Release GID”
"- Order Release Dimensions"."Order Release Reference Number Qualifier GID"
"- Order Release Dimensions"."Order Release Reference Number Qualifier XID"
"- Order Release Dimensions"."Order Release Reference Number Qualifier Description"
"- Order Release Dimensions"."Order Release Reference Number Value"
4. Add a filter that selects a specific Order Release GID.
5. Under the results tab, the report shows Order Release Reference Number Values that belong to other Order Release GIDs as the respective filtered Order Release GID

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.