My Oracle Support Banner

OBIEE: MBA - Top 10 Product Affinities Report Shows Error On OBIEE 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 FEBRUARY 17, 2019

Applies to:

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


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)



 Upgraded from to


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

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