My Oracle Support Banner

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 later
Information 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


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