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

Last updated on OCTOBER 16, 2016

Applies to:

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

Symptoms

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".



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