OBIA 11g : Is There A Dimension In OBIA Datawarehouse For MTL_ITEM_SUB_INVENTORIES?
(Doc ID 1964295.1)
Last updated on FEBRUARY 03, 2019
Applies to:Business Intelligence Applications Consumer - Version 18.104.22.168.1 and later
Information in this document applies to any platform.
Implementing OBIA 22.214.171.124.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?
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