OBIA 22.214.171.124.1: NO OWNER_WID INFORMATION IN W_ACTIVITY_F TABLE IN OBIA
Last updated on AUGUST 12, 2017
Applies to:Business Intelligence Applications Consumer - Version 126.96.36.199.1 and later
Information in this document applies to any platform.
On : 188.8.131.52.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.
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