Fusion OTBI - Unable To Create Cross Subject Area Analysis With "Sourcing - Supplier Negotiations Real Time" Subject Area (Doc ID 2194829.1)

Last updated on DECEMBER 08, 2016

Applies to:

Oracle Fusion Product Hub Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to run following analysis the following error occurs.

SET VARIABLE ENABLE_DIMENSIONALITY=1, NO_FORCE_TO_DETAIL_BIN=1;
SELECT
0 s_0,
"Procurement - Purchasing Real Time"."- Purchase Order Line Detail"."Price" s_1,
"Sourcing - Supplier Awards Real Time"."- Award Line Detail"."Award Price" s_2,
"Sourcing - Supplier Awards Real Time"."- Negotiation Line Detail"."Estimated Quantity" s_3,
"Sourcing - Supplier Awards Real Time"."- Negotiation Line Detail"."Negotiation Start Price" s_4,
"Sourcing - Supplier Awards Real Time"."Procurement BU"."Procurement Business Unit Name" s_5,
"Sourcing - Supplier Awards Real Time"."Procurement Item"."Category Name" s_6,
"Sourcing - Supplier Awards Real Time"."Procurement Item"."Procurement Item Type" s_7,
"Sourcing - Supplier Awards Real Time"."Supplier Profile"."Supplier Name" s_8,
"Sourcing - Supplier Awards Real Time"."Supplier Profile"."Supplier Type" s_9,
"Procurement - Purchasing Real Time"."- Purchase Order Line"."Ordered Quantity" s_10
FROM "Sourcing - Supplier Negotiations Real Time"
ORDER BY 1, 6 ASC NULLS LAST, 3 ASC NULLS LAST, 9 ASC NULLS LAST, 10 ASC NULLS LAST, 4 ASC NULLS LAST, 5 ASC NULLS LAST, 7 ASC NULLS LAST, 8 ASC NULLS LAST, 2 ASC NULLS LAST
FETCH FIRST 75001 ROWS ONLY

ERROR
-----------------------
[2016-09-21T09:50:40.546+00:00] [OracleBIServerComponent] [TRACE:2] [] [] [ecid: 005FG5uJAvp1zWCpnCO5yZ0000k20008GE,0:4:1:8:5] [tid: 2af60700] [messageid: USER-34] [requestid: 5170002] [sessionid: 5170000] [username: ashish.miglani.external@g4s.com] -------------------- Query Status: [nQSError: 15018] Incorrectly defined logical table source (for fact table Z - VO OBIA ETL) does not contain mapping for [Dim - Purchase Order Details.Unit Price]. [[


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create an analysis with the above logical SQL.
2. Try to run it.


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