My Oracle Support Banner

OBIA 11g: SDE_ORAR122_ADAPTOR_SDE_ORA_INVENTORYDAILYBALANCEFACT Fails When Extracting Data From SDS Schema (Doc ID 2136890.1)

Last updated on FEBRUARY 21, 2019

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.
EBS 12.2

Symptoms

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

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
Symptoms
Changes
Cause
Solution
References


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