Task SDE_PSFT_DomainGeneral_ProductCategories_HierarchyLevelName Fails During Full Data Load (Doc ID 2004211.1)

Last updated on APRIL 29, 2015

Applies to:

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

Symptoms

On : OBIA 11.1.1.8.1 , DataWarehouse

Customer performs a first time full data load.  As part of the Load Plan, running Task SDE_PSFT_DomainGeneral_ProductCategories_HierarchyLevelName

Task fails with the following error:

ODI-1228: Task SDE_PSFT_DomainGeneral_ProductCategories_HierarchyLevelName (Integration) fails on the target ORACLE connection BIAPPS_DW.
Caused By: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DEV_DW.W_DOMAIN_MEMBER_GS_U1) violated



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