OBIA 11.1.1.8.1: 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 11.1.1.8.1 and later
Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.160119 to 11.1.1.7.160119 [Release 11g]
Information in this document applies to any platform.

Goal

You have OBIA 11.1.1.8.1 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)
 

Solution

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