My Oracle Support Banner

NO FACT TABLE EXISTS WHEN ADDING DFF TO SALES ORDERS AND SHIPMENTS IN OTBI (Doc ID 2670824.1)

Last updated on MAY 25, 2020

Applies to:

Oracle Fusion Order Management Cloud Service - Version 11.13.20.01.0 and later
Information in this document applies to any platform.

Symptoms


When using these 2 Subject Area's:
"Distributed Order Orchestration - Fulfillment Lines Real Time"
"Shipping Real Time"

When adding Descriptive Flex Field/DFF to the "Shipping Real Time" the Analysis errors with:
[nQSError: 14025] No fact table exists at the requested level of detail:

The analysis works ok with both Subject Areas up until the flex field "Shipping Real Time"."- Shipment Details"."WSH_NEW_DELIVERIES_LOCATIONLOADID_" is added.

The analysis works ok when using just use these 2 columns:
"Shipping Real Time"."- Shipment Details"."Shipment Number"
"Shipping Real Time"."- Shipment Details"."WSH_NEW_DELIVERIES_LOCATIONLOADID_"

 

Changes

 Added the flex field "Shipping Real Time"."- Shipment Details"."WSH_NEW_DELIVERIES_LOCATIONLOADID_"

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
References


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