My Oracle Support Banner

Metric Handler error: 'ORA-01422: exact fetch returns more than requested number of rows (Doc ID 550175.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Utilities Work and Asset Management - Version 1.7.5 and later
Information in this document applies to any platform.


A custom metric was created and successfully added to the homepage, however there is no current
value showing up. The metric was set up to use the SQL Query 'Select inventory_quantity from sa_storeroom' and the filters are SA_STOREROOM.STOCK_CODE='000000000000001' AND SA_STOREROOM.STOREROOM='WTL' .

The Metric Handler batch job displays the following error message for the metric:

ERROR: ORA-01422: exact fetch returns more than requested number of rows - Attempting to execute
"Select inventory_quantity from sa_storeroom".


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

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