OBIA 11.1.1.10.1 - PSFT 9.x - EBS - DATASOURCE_NUM_ID is Not Used In Filter Condition to identify Employee ID separately (Doc ID 2180576.1)

Last updated on JULY 17, 2017

Applies to:

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

Symptoms

When a customer has multiple HR Sources registered in BIACM to populate warehouse, using single load plan, customers face issue while loading the Person dimension table, if the same Emplid is present in both the sources.

For Example -

Customer has two HR sources PSFT 9.1 and PSFT 9.2 registered in BIACM.

When loading the tables 

W_PSFT_HR_PSN_NAMES_PS
W_PSFT_HR_PSN_HIST_PS

From SDE_PSFT_HRPersonDimension since the filter does not have DATASOURCE_NUM_ID condition and hence the same EMPLID has two records trying to be loaded in the table.

 

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