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 FEBRUARY 02, 2022
Applies to:
Business Intelligence Applications Consumer - Version 7.9.6.3 [AN 1900] and laterInformation in this document applies to any platform.
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,
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
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
| Symptoms |
| Cause |
| Solution |