Incremental ETL is failing with the error "ORA-01422: exact fetch returns more than requested number of rows" (Doc ID 1562721.1)

Last updated on JULY 13, 2023

Applies to:

Symptoms

ETL failed with the following email notification:

-----Original Message-----
From: Insight ETL Mail Service [mailto:SafetyAdmins@oracle.com]
Sent: Friday, June 14, 2013 2:52 PM
To: Safety Admins
Subject: Argus Insight ETL => FAILURE!! (Database = AS00I01)

Oracle Corporation
Argus Insight Application => Automatic Email Generation

Incremental ETL FAILED to complete on database AS00I01

Total ETL Time => 3 Hours 59 Mins 55 Seconds

ETL Start Time => 14-JUN-2013 10:48:48 AM
ETL End Time => 14-JUN-2013 02:48:43 PM

Error Message = ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APR_STAGE.PKG_PWR_STAGE_UTIL", line 650
ORA-06512: at "APR_STAGE.PKG_AIR_ATOS_INCR", line 3011
ORA-06512: at "APR_MART.PKG_DBMS_JOB", line 1498


To review further details, please check following LOG tables:
1) ETL_JOBS
2) STAGING_DATA_INSERT_LOG
3) MART_DATA_INSERT_LOG

Changes

Cause

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