OBIA 220.127.116.11.1 - PSFT 9.x - EBS - DATASOURCE_NUM_ID is Not Used In Filter Condition to identify Employee ID separately
Last updated on JULY 17, 2017
Applies to:Business Intelligence Applications Consumer - Version 18.104.22.168.1 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