My Oracle Support Banner

OBIA 11.1.1.8.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 11.1.1.8.1 and later
Information in this document applies to any platform.

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

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

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
Goal
Solution


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