SDE_ORAR122_ADAPTOR_SDE_ORA_INVENTORYDAILYBALANCEFACT Fails Pulling from SDS Schema (Doc ID 2136890.1)

Last updated on JUNE 06, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.10.1 to 11.1.1.10.1 [Release 11g]
Information in this document applies to any platform.

Symptoms

OBIA 11.1.1.10.1
ODI version 11.1.1.9.0

EBS 12.2

SDE_ORAR122_ADAPTOR_SDE_ORA_INVENTORYDAILYBALANCEFACT works pulling from EBS tables, but Full Load fails pulling from SDS schema. All other SDE's for other modules are all working.



Changes

 Check ODI and make sure the task "SDE_ORA_INVENTORYDAILYBALANCEFACT" is getting included in the load plan.

The ODI load plan should include the mapping SDE_ORA_INVENTORYDAILYBALANCEFACT to load W_INVENTORY_DAILY_BAL_FS.

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