OBIA 220.127.116.11.1: Inventory In Balances Subject Area of Seeded OBIA
(Doc ID 2280116.1)
Last updated on OCTOBER 04, 2019
Applies to:Business Intelligence Applications Consumer - Version 18.104.22.168.1 and later
Information in this document applies to any platform.
Created custom lookup table to use for added fields from the seeded Inventory - Balances Subject Area with OBIA 22.214.171.124.1
The key to the Lookup Table is Item Number and Organization_ID.
This works by adding a logical column to the Dim - Item Dimension in BMM and used "Core"."Dim - Item"."Part Number" as the Item Number. Additionally hard-coding the organization_id to the master org id number.
However, how to expand this so that it uses the Organization_ID for the inventory org that is being queried?
Where is the org id from found?
The lookup with the hard coded org_id is "LOOKUP ( SPARSE "Core"."XXLFI_ITEM_ORG_CUSTOMER_CODE_LKP"."CUSTOMER_NAME", 'None_Assigned', "Core"."Dim - Item"."Part Number", 83)".
How to replace the 83 number at the end?
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