OBIA 11g Union Name in OOTB RPD Does not have any Data in the Database (Doc ID 2060739.1)

Last updated on JULY 17, 2017

Applies to:

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

Goal

There is a field UNION_NAME in the 'Dim - Employment' folder of logical layer in the delivered OOTB RPD.
‘Union Name’ is supposed to be name/description of ‘Union Code’ field which is present in W_EMPLOYMENT_D table.

In the RPD, Union name is a derived column and the function is as follows:
LOOKUP( DENSE "Core"."Lookup - Domain Source"."Domain Member Name", 'WORKER_UNION', "Core"."Dim - Employment"."Salary Basis Code", VALUEOF(NQ_SESSION."USER_LANGUAGE_CODE"), "Core"."Dim - Employment"."Source Id")

Also, the Lookup - Domain Source is as follows:


"Core"."Lookup - Domain Source" = “SELECT
DOMAIN_CODE AS Domain_Code,
DOMAIN_MEMBER_CODE AS Domain_Member_Code,
DOMAIN_MEMBER_DESCR AS Domain_Member_Description,
DOMAIN_MEMBER_NAME AS Domain_Member_Name,
LANGUAGE_CODE AS Language_Code,
DATASOURCE_NUM_ID AS Source_ID
FROM W_DOMAIN_MEMBER_LKP_TL
WHERE DOMAIN_TYPE_CODE = 'S'”


But there is no data for 'WORKER_UNION' in the domain_code column and also in the domain mapping in BIACM.
 

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