My Oracle Support Banner

OBIA Inventory In Balances Subject Area of Seeded OBIA (Doc ID 2280116.1)

Last updated on APRIL 15, 2021

Applies to:

Business Intelligence Applications Consumer - Version 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

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 primary 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?

For example:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.