Exalytics and OBIA 11.1.1.7.1 - Peoplesoft Workforce Headcount Is Wrong When Running Incremental Load In ODI (Doc ID 2294469.1)

Last updated on AUGUST 17, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.7.1 and later
Oracle Exalytics Software - Version 1.0.0.3.0 and later
Information in this document applies to any platform.

Symptoms

When using ODI version 11.1.1.7.0_Generic_130302.2156 and BI Apps 11.1.1.7.160719, incorrect data is being generated when running the target Peoplesoft Workforce mapping named "SDE_PSFT_WorkforceEventFact."
If a full load is done in Oracle Data Integrator (ODI), the headcount is as expected and can be validated by comparing to data in PeopleSoft, SQL and in OBIA Analytics.  If an incremental load is done, there are duplicate headcounts.

After noticing the duplicate headcounts, a full load was run again and it removed the duplicate headcounts. Then an incremental run was performed the following night. After this the duplicate headcount reappeared.

This problem is occurring on an Exalytics, Linux 5 OVM server when using Peoplesoft 9.2 source system and BI Apps modules Workforce Deployment, Workforce effectiveness, Compensation, Payroll, and Absence and Leave Accrual.  Although, this problem is occurring on an Exalytics server, it is not unique to Exalytics and can occur in any OBIA environment on any operating system.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms