OBIA 7963 ORA-01427: Single-row Subquery Returns More Than One Row error in 'SIL_PositionDimensionHierarchy_AsIsUpdate_ORCL' Workflow (Doc ID 1488791.1)

Last updated on JANUARY 30, 2017

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6.3 [AN 1900] and later
Information in this document applies to any platform.
Checked for Relevance 05-Jan-2015

Symptoms

BI Apps 7.9.6.3 ETL fails with the following error in the 'SIL_Vert.SIL_PositionDimensionHierarchy_AsIsUpdate_ORCL' Workflow :

Target tables: W_POSITION_DH

READER_1_1_1> RR_4010 SQ instance [SQ_W_DUAL_G] SQL Query [SELECT W_DUAL_G.DATASOURCE_NUM_ID, W_DUAL_G.ETL_PROC_WID, W_DUAL_G.INTEGRATION_ID, W_DUAL_G.ROW_WID, W_DUAL_G.X FROM W_DUAL_G WHERE W_DUAL_G.ROW_WID = 1]
READER_1_1_1> RR_4049 SQL Query issued to database : (Wed Sep 05 09:26:49 2012)
READER_1_1_1> RR_4050 First row returned from database to reader : (Wed Sep 05 09:26:49 2012)
READER_1_1_1> BLKR_16019 Read [1] rows, read [0] error rows for source table [W_DUAL_G] instance name [W_DUAL_G]
READER_1_1_1> BLKR_16008 Reader run completed.
TRANSF_1_1_1> DBG_21216 Finished transformations for Source Qualifier [SQ_W_DUAL_G]. Total errors [0]
WRITER_1_*_1> WRT_8167 Start loading table [W_POSITION_DH] at: Wed Sep 05 09:26:49 2012
WRITER_1_*_1> CMN_1761 Timestamp Event: [Wed Sep 05 09:26:49 2012]
WRITER_1_*_1> WRT_8229 Database errors occurred:
ORA-01427: single-row subquery returns more than one row

Database driver error...
Function Name : Execute
SQL Stmt : UPDATE
W_POSITION_DH DH1
set
(DH1.CURRENT_BASE_POSTN,
  DH1.CURRENT_BASE_POSTN_ID,

 

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