My Oracle Support Banner

FTI Data For Invoice Contains Accessorial Data That Is Not Correct (Doc ID 2286730.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Fusion Transportation Intelligence - Version 6.4.1 and later
Oracle Transportation Intelligence Cloud Service - Version 6.4.1 and later
Information in this document applies to any platform.


An Invoice is created in OTM and ETL run.
No edits were made to the invoice before or after the ETL was run.
The filtered FTI report returns much accessorial data than is expected for this report.

Steps to reproduce:

1. Navigate to Transportation Intelligence> Adhoc Query> Analysis and Interactive Reporting > Analysis
2. Select the following to build the adhoc query
Invoice Line Analysis>Invoice Line Facts>Freight Charge Base
3. Add the following from Invoice Line Analysis
Invoice Line Analysis>Invoice Line Dimensions>Invoice Gid
Invoice Line Analysis>Invoice Line Dimensions>Accessorial Code
Invoice Line Analysis>Invoice Line Dimensions>Accessorial Code Description
4. Add a filter to pull only the specific invoice
Invoice GID is equal to / is in "invoice gid"
5. Click Results
Incorrect data is returned (data is not filtered correctly)



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.