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


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


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