My Oracle Support Banner

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 and later
Information in this document applies to any platform.


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



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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.