OBIA 11g: Load Fails When SDS Schema is Activated as Source Instead of EBS

(Doc ID 2297354.1)

Last updated on AUGUST 28, 2017

Applies to:

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

Symptoms

OBIA 11.1.1.10.2
Using SDS schema to load the data and using Golden Gate 12.2.0.1. SDS data is populated with initial load data and now the need is to load this data into OBIA Data Warehouse.
Source: EBS R12.1.3
Target database: Oracle 11.2.0.4.0.

Have completed the Full load of EBS without Golden Gate and works fine and now trying to use SDS schema to get this accomplished.



Chose IS_SDS_DEPLOYED to Yes and MAX_W_MCAL_CAL_D_ROW_WID variable fails to evaluate the value and this is the SQL being used in this variable:
When the variable is run (refreshed) in context of the Manufacturing Analytics Full Load with IS_SDS_DEPLOYED set to "Y", ODI erroneously qualifies an OBIA Data Warehouse table (W_MCAL_CAL_D) with a Source Schema name (sdsSchemaName) -- instead of qualifying it with the Data Warehouse Schema name (OBIA_DW) as the case statement's Else Clause does.

 

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