OBIA 11g: Load Fails When SDS Schema is Activated as Source Instead of EBS
(Doc ID 2297354.1)
Last updated on FEBRUARY 07, 2019
Applies to:Business Intelligence Applications Consumer - Version 184.108.40.206.2 and later
Information in this document applies to any platform.
Using SDS schema to load the data and using Golden Gate 220.127.116.11. 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 18.104.22.168.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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document