My Oracle Support Banner

There Is No Country Code Information in Logical / Presentation Layer of OBIEE (Doc ID 2177358.1)

Last updated on JUNE 07, 2019

Applies to:

Oracle Retail Merchandising Insights - Version 15.0 and later
Information in this document applies to any platform.

Goal

There is no Country Code information in the logical/presentation layer column of Oracle Business Intelligence Enterprise Edition (OBIEE).

The country code in Retail Merchandising System (RMS) (ADDR.COUNTRY_ID) is mapping to Retail Insights (RI) as follows:

ADDR.COUNTRY_ID
  --> W_RTL_ORG_D_TMP.W_COUNTRY_CODE
  --> W_INT_ORG_DS.W_COUNTRY_CODE
  --> W_INT_ORG_D.W_COUNTRY_CODE

However, there is no logical column mapping to this field. 

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.