OBIA 11g : Is There A Dimension In OBIA Datawarehouse For MTL_ITEM_SUB_INVENTORIES? (Doc ID 1964295.1)

Last updated on JANUARY 31, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.8.1 and later
Information in this document applies to any platform.

Goal

Implementing OBIA 11.1.1.8.1 SCM and Order Management Analytics. Source System is Oracle EBS R12.2.4.

The existing data warehouse model has dimension W_INVENTORY_PRODUCT_D which is sourced from MTL_SYSTEM_ITEMS_B. You are capturing certain key business attributes at sub-inventory level i.e.MTL_ITEM_SUB_INVENTORIES. These are captured in standard fields of MTL_ITEM_SUB_INVENTORIES

How can you include these attributes in the Inventory BI reports.

Please advise on following points:

1. Does W_INVENTORY_PRODUCT_D capture information at Item-Sub inventory level?
2. Else Is there any dimension in existing OBIA data-warehouse model corresponding to MTL_ITEM_SUB_INVENTORIES?
3. Else Is it advisable to customize W_INVENTORY_PRODUCT_D to meet our requirement or create new Dimension?
 

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