OBIEE: MBA - Top 10 Product Affinities Report Shows Error On OBIEE 11.1.1.7 on Retail Customer Analytics 13.3.6 ,OPR4ONWY:U9IM8TAC:OI2DL65P & NQSERROR:15018 ERROR WITH ORACLE RETAIL OTBI REPORT (Doc ID 2035953.1)

Last updated on JULY 17, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.0 to 11.1.1.7.150714 [Release 11g]
Information in this document applies to any platform.

Symptoms

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 15018] Incorrectly defined logical table source (for fact table Fact – MBA Top 10 Product Affinities) does not contain mapping for [Dim - Item.Source ID, Dim - Item.If Dept1 Lookup, Dim - Item.If Dept2 Lookup, Dim - Item.If Dept3 Lookup, Dim - Item.Then Dept Lookup]. (HY000)

 

Changes

 Upgraded from 11.1.1.6.X to 11.1.1.7.150120

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