OBIA 11g Loading from Dual Sources for Different Offerings Some Common DW Tables Populated Only by One Source. Ex: W_PROJ_RSRC_UTILIZATION_FS
(Doc ID 2215201.1)
Last updated on MARCH 28, 2018
Applies to:Business Intelligence Applications Consumer - Version 184.108.40.206.1 and later
Information in this document applies to any platform.
Some OOTB Interfaces like SIL_ProjectUtilizationFact.W_PROJ_RSRC_UTILIZATION_F have join conditions based on the DATASOURCE_NUM_ID configuration.
For example: W_PROJ_RSRC_UTILIZATION_FS.DATASOURCE_NUM_ID=EMPLOYEE_D.DATASOURCE_NUM_ID
For example: The table W_PROJ_RSRC_UTILIZATION_FS is coming from PeopleSoft Resource Management (RM) so the DATASOURCE_NUM_ID = 5 and W_EMPLOYEE_D is coming from PSFT Human Resources (HR) so DATASOURCE_NUM_ID = 1
This is going to be the case for many other ETLs as we are implementing OBIA HR, Projects and Finance coming from different sources. We notice that some common tables like W_EMPLOYEE_D are getting populated by HR only.
What is the approach to fix this from the configuration point of view?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!