OBIA 11g - Incorrect PROD_CAT Values are Populated in W_PRODUCT_DS After Second Full Load (Doc ID 2057814.1)

Last updated on SEPTEMBER 21, 2015

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.8.1 and later
Information in this document applies to any platform.

Symptoms

Configuring new product category set ids for BIACM in a test environment. Due to a previous full load, data exists in W_PRODUCT_D with the old product category set ids. With a second full load, the SDE_ORA_ProductDimension_Derive mapping is bringing in the old prod cat1 values from W_PRODUCT_D. Causing incorrect data to be populated in W_PRODUCT_DS.



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