My Oracle Support Banner

OBIA 11g: Fact Tables Data Is Not Loaded In To Warehouse When Load Plan Loading From Two Sources (Doc ID 2504609.1)

Last updated on AUGUST 14, 2019

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.10.2 to 11.1.1.10.2 [Release 11g]
Information in this document applies to any platform.
Dual Sources, EBS 12.1.3 and Siebel 8.1.1

Symptoms

OBIA 11.1.1.10.2 Fact tables data is not loaded in to warehouse. For example these two w_ap_xact_f and w_ar_xact_f While some other tables are loaded.
This involves 2 sources, EBS 12.1.3 , Siebel 8.1.1.

When trying to generate a load plan to contain both sources, some fact groups are missing when selecting all options from source instance.

Separate load plans (one for each source) and all fact groups are loaded 

Why does the generated Load Plan containing both sources not load all the data, while the individual source load plans do load all the data.

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