OBIA 7.9.6.4: PeopleSoft (PSFT) Data Out Of Balance In DW
(Doc ID 2681331.1)
Last updated on JUNE 19, 2020
Applies to:
Business Intelligence Applications Consumer - Version 7.9.6.4 and laterInformation in this document applies to any platform.
Symptoms
OBIA: 7.9.6.4 version, DataWarehouse
OBIEE 11.1.1.7
DAC 11.1.1.6
OBIA Modules: Finance, Retail
Informatica 9.5.1
Source system Peoplesoft: 9.2
Balance Global1 Amount, and Activity are not zero in the DW after a few Incremental updates. Thus, there is a mismatch between the source PSFT and the DW. Yet, after a Full Load all is fine, as well as after a few Incremental Loads.
What is expected is to have consistent and correct data in the DW after the Incremental Loads.
Steps to reproduce: The issue can be reproduced at will with the following steps:
1. Execute a Full Load. All data is correct.
2. Execute a few Incremental Loads. Data is still correct.
3. After certain date, the Incremental Load is getting this mismatch.
Changes
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 |