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

Last updated on APRIL 15, 2021

Applies to:

Goal

Created custom lookup table to use for added fields from the seeded Inventory - Balances Subject Area with OBIA 11.1.1.8.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 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?

Solution

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