OBIA 11g: Load Fails When SDS Schema is Activated as Source Instead of EBS
Last updated on AUGUST 28, 2017
Applies to:Business Intelligence Applications Consumer - Version 126.96.36.199.2 and later
Information in this document applies to any platform.
Using SDS schema to load the data and using Golden Gate 188.8.131.52. 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 184.108.40.206.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.
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