OBIA 11.1.1.8.1: NO OWNER_WID INFORMATION IN W_ACTIVITY_F TABLE IN OBIA (Doc ID 2246031.1)

Last updated on AUGUST 12, 2017

Applies to:

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

Symptoms

On : 11.1.1.8.1 version, DataWarehouse

NO OWNER_WID INFORMATION IN W_ACTIVITY_F TABLE IN OBIA

OWNER_WID are all 0's in the W_ACTIVITY_F TABLE, due to which the employee details cannot be mapped with the activities in Service CRM Activities Subject Area.
In ODI Package found that the OWNER_WID in the ACTIVITY_F table is defined from the following expression

and ROW_WID in LKP_W_EMPLOYEE_D is defined from ROW_WID of W_EMPLOYEE_D table and there is no valid ROW_WID's under Employee dimension table.

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