OBIA: Project Revenue Fact - Financial Resource WID Is 0
(Doc ID 2319653.1)
Last updated on OCTOBER 20, 2017
Applies to:Business Intelligence Applications Consumer - Version 184.108.40.206.2 and later
Information in this document applies to any platform.
While validating the data warehouse (DWH), noticed that over 99% of the Financial Resource WIDs in the Project Revenue Fact (W_PROJ_REVENUE_LINE_F) are 0.
Further analysis, noticed that the staging table (W_PROJ_REVENUE_LINE_FS) has most of the rows with value for column "FINANCIAL_RESOURCE_ID".
These values do not match the ones in the staging table for the Financial Resource dimension (W_FINANCIAL_RESOURCE_DS.INTEGRATION_ID), even though it has over 24 million rows.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!