My Oracle Support Banner

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

Last updated on MAY 06, 2019

Applies to:

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


When using ODI version and BI Apps, 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.


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.