OBIA 126.96.36.199.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 188.8.131.52.1 and later
Information in this document applies to any platform.
On : 184.108.40.206.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.
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