OBIA 188.8.131.52: 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 184.108.40.206 and later
Information in this document applies to any platform.
OBIA: 220.127.116.11 version, DataWarehouse
OBIA Modules: Finance, Retail
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.
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