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

Last updated on SEPTEMBER 06, 2016

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 OBIEE.

The country code in RMS (ADDR.COUNTRY_ID) is mapping to 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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms