My Oracle Support Banner

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


Using SDS schema to load the data and using Golden Gate 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

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.