My Oracle Support Banner

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 OCTOBER 22, 2013

Applies to:

Oracle Argus Insight - Version 7.0.2 and later
Information in this document applies to any platform.


ETL has been failing since last Friday. Below is the email notification we are receiving:

-----Original Message-----
From: Insight ETL Mail Service []
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:


To view full details, 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 a vibrant support community of peers and Oracle experts.