My Oracle Support Banner

FDI: Metrics Such as Budget, Raw Costs, Commitments in PPM Subject Area Show Doubling/Inflation (Doc ID 3015904.1)

Last updated on APRIL 19, 2024

Applies to:

Fusion Analytics Warehouse - Version 23.R4.x and later
Information in this document applies to any platform.

Symptoms

For a particular user, all metrics such as Budget, Raw Costs, and Commitments derived from the PPM Subject area are duplicated. This user holds two custom roles: XXX Project Administrator and XXX Project Controller.

Both of these custom roles are linked to the OOTB Project Manager role. Further investigation revealed that in the DW_PROJECT_ROLE_TYPE_D table, the ROLE_ID for three roles is populated as -99999. Among these records, one corresponds to PROJECT_ROLE_ID = 1, which signifies the project manager role.

Note: The metric values are accurate for other users, as well as for recreated users with identical security and access settings.

Changes

NA

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.