My Oracle Support Banner

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

Goal

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?
 

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.