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

Last updated on JULY 14, 2017

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.

Symptoms

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)

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms