OBIA 11g Task SDE_ORA_Stage_CostCenterDimensionHierarchy shows ORA-01427 error for Incremental Load After Applying Solution in Note 1991911.1 (Doc ID 2017641.1)

Last updated on AUGUST 09, 2016

Applies to:

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

Symptoms

You have applied the fix discussed in <Note 1991911.1> OBIA 11g SDE_ORA_CostCenterDimensionHierarchy is taking lot of disk space.  However, since then, during every incremental load plan, the task SDE_ORA_Stage_CostCenterDimensionHierarchy fails on the step Update Existing Rows with the error

ORA-01427: single-row subquery returns more than one row

 

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