My Oracle Support Banner

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

Last updated on MARCH 10, 2019

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.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.