OBIA: SIL_PositionDimensionHierarchy returns: ORA-01427: Single-row Subquery Returns More Than One Row

(Doc ID 2226325.1)

Last updated on OCTOBER 15, 2017

Applies to:

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

Symptoms

Problem Description
---------------------------------------------------

The following error during the incremental load ODI-1228: Task SIL_PositionDimensionHierarchy.W_POSITION_DH (Integration) fails on the target ORACLE connection BIAPPS_DW.
Caused By: java.sql.SQLException: ORA-01427: single-row subquery returns more than one row.

I believe this to be caused from records having the same timestamp (which I'm not sure how that happens), and I'm not sure what the solution is. Any help is greatly appreciated.

Error Codes
---------------------------------------------------
01427

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