My Oracle Support Banner

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


OBIA: version, DataWarehouse
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.




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

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