OBIA 11g : Is There A Dimension In OBIA Datawarehouse For MTL_ITEM_SUB_INVENTORIES?
Last updated on JANUARY 31, 2017
Applies to:Business Intelligence Applications Consumer - Version 22.214.171.124.1 and later
Information in this document applies to any platform.
Implementing OBIA 126.96.36.199.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?
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