My Oracle Support Banner

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

Last updated on FEBRUARY 14, 2019

Applies to:

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


Implementing OBIA 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?


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.