OBIA 11g Union Name in OOTB RPD Does not have any Data in the Database
Last updated on JULY 17, 2017
Applies to:Business Intelligence Applications Consumer - Version 184.108.40.206.1 and later
Information in this document applies to any platform.
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
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.
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