Data Warehouse creation using DAC 11g fails in BI Apps 7.9.6.4 (Doc ID 1914689.1)

Last updated on AUGUST 21, 2014

Applies to:

Business Intelligence Applications Observer - Version 7.9.6.4 to 7.9.6.4 [Release V7]
Information in this document applies to any platform.

Symptoms

The following error message is displayed while trying to create warehouse tables from DAC:

Table Name : W_INTL_ASSGN_D
Column Name: CREATED_BY_WID.
The column properties that are different :[statistics]
---------------------------------------------
EXCEPTION CLASS:::
com.siebel.analytics.etl.sqlgen.disambiguator.TableDescriptorDisambiguatorException


Further research shows that the same issue exists with table W_PSFT_GLHIER_FLAT_DH_TMP and W_PSFT_GLHIER_VERT_DH_TMP

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