My Oracle Support Banner

Data Corruption in Multi-Dimensional Schema (MDS) after Full Load (Doc ID 2770457.1)

Last updated on APRIL 26, 2021

Applies to:

Oracle Product Lifecycle Analytics - Version 3.4.0 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR  

After running Full Load , some fields like

Schedule

Actual Dates

Region details

Supplier details

in MDS tables are not matching with Agile Product Portfolio Management(PPM) Source Data.

Due to this issue the Business Intelligence(BI) reports are showing incorrect data.

However, the Data Mart (DM) tables have the correct data.


EXPECTED BEHAVIOR

After Full Load, all the details in MDS tables should match with Agile PPM Source Data and BI reports should show the correct data.


STEPS

The issue can be reproduced at will with the following steps:

1. Run Full Load.
2. Verify the details like Schedule, Actual Dates, Region details, Supplier details in MDS tables.
3. The data is seen to be not matching with the one in Agile.
4. Due to this issue Business Intelligence(BI) reports are showing incorrect data.

Changes

 Modified dynamic list configuration in Agile environment.

Bug 30164201 - DATA CORRUPTION IN FULL LOAD Bug 30164201 - DATA CORRUPTION IN FULL LOAD Bug 30164201 - DATA CORRUPTION IN FULL LOAD Bug 30164201 - DATA CORRUPTION IN FULL LOAD Bug 30164201 - DATA CORRUPTION IN FULL LOAD 

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.