My Oracle Support Banner

FTI Analysis Throwing Error 'No fact table exists at the requested level of detail' When Invoice GID And Shipment Tracking Event Dimension Columns Are Added Together (Doc ID 3042576.1)

Last updated on AUGUST 27, 2024

Applies to:

Oracle Transportation Management Cloud Service - Version 24.2 and later
Information in this document applies to any platform.

Symptoms

OTM FTI Analysis unable to retrieve the invoice data for respective shipment tracking event.
It is throwing error when Invoice and Shipment Tracking Event Dimension columns are added together.

Sample Error Stack

Changes

N/A 

Cause

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
Symptoms
Changes
Cause
Solution


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