Data Discrepancies in Reporting Due to Issues with SIL_EMPLOYEEDIMENSION Incremental Load Not loading into Target Dimension (Doc ID 2030679.1)

Last updated on AUGUST 09, 2016

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6.3 [AN 1900] and later
Information in this document applies to any platform.

Symptoms

There is a difference in the staging data and the dimension data for W_EMPLOYEE_D  and W_EMPLOYEE_DS for the column HELD_POSTN and PR_POSTN columns. Staging has the right data and that data isn't being updated in target dimension for HELD_POSTN and PR_POSTN columns in incremental load.

This is causing data discrepancies in our reporting

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