FTI Invoice Analysis Ad Hoc Report Displays Payment Reference Numbers of Other Invoices when Filtering on a Specific Invoice (Doc ID 2121396.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
An Invoice Type report is being built within Fusion Transportation Intelligence with the following columns specified to be displayed:
"- Invoice Dimensions"."Invoice GID”
"- Invoice Dimensions"."Payment Reference Number Qualifier GID"
"- Invoice Dimensions"."Payment Reference Number Qualifier XID"
"- Invoice Facts"."Payment Reference Number Value"

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

EXPECTED BEHAVIOR
-----------------------
It is expected that the report only show the Payment Reference Number values of the respective Invoice GID that has been filtered on and not show any other values that are not tied to that Invoice 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 Invoice Analysis -> Invoice Dimensions.
3. Add the following columns to the report:
"- Invoice Dimensions"."Invoice GID”
"- Invoice Dimensions"."Payment Reference Number Qualifier GID"
"- Invoice Dimensions"."Payment Reference Number Qualifier XID"
"- Invoice Facts"."Payment Reference Number Value"
4. Add a filter that selects a specific Invoice GID.
5. Under the results tab, the report shows Payment Reference Number Values that belong to other Invoice GIDs as the respective filtered Invoice GID

Cause

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