OBIA: Project Revenue Fact - Financial Resource WID Is 0
Last updated on OCTOBER 20, 2017
Applies to:Business Intelligence Applications Consumer - Version 18.104.22.168.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.
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