My Oracle Support Banner

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


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.


To view full details, 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 a vibrant support community of peers and Oracle experts.