OBIA SCM: Days Inventory Outstanding by Inventory Organization report error

(Doc ID 1970570.1)

Last updated on AUGUST 09, 2016

Applies to:

Business Intelligence Applications Consumer - Version and later
Business Intelligence Suite Enterprise Edition - Version to [Release 11g]
Information in this document applies to any platform.


You have OBIA Out Of the Box (OOB) configured for SCM Module. For this you are getting below error for Days Inventory Outstanding by Inventory Organization report under Inventory--Balances dashboard page.

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 15018] Incorrectly defined logical table source (for fact table Fact - Sales - Cycle Line) does not contain mapping for [Dim - Inventory Org.Inventory Org Key]. (HY000)


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