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 11.1.1.10.2 and later
Information in this document applies to any platform.

Symptoms

OBIA 11.1.1.10.2
PeopleSoft 9.2.

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.

Cause

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