OBIA 11g Wrong Expression Used In 'DOMAIN_COL1_MEMBER_CODE' & 'DOMAIN_COL2_MEMBER_CODE' Columns in BI Apps 11.1.1.9.2 SDE_ORA_DomainGeneral_Multi_WorkerType Mapping (Doc ID 2063483.1)

Last updated on JANUARY 31, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.9.2 and later
Information in this document applies to any platform.

Symptoms

The columns DOMAIN_COL1_MEMBER_CODE and DOMAIN_COL2_MEMBER_CODE have been assigned the wrong expressions and they are the wrong way round

e.g. :

DOMAIN_COL1_MEMBER_CODE = TO_CHAR(PER.PERSON_TYPE_ID)
DOMAIN_COL2_MEMBER_CODE = PER.SYSTEM_PERSON_TYPE


Correct mapping:

DOMAIN_COL1_MEMBER_CODE = PER.SYSTEM_PERSON_TYPE
DOMAIN_COL2_MEMBER_CODE = TO_CHAR(PER.PERSON_TYPE_ID)


Cause

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