OBIA - 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 and later
Information in this document applies to any platform.


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 


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.



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