Metric Handler error: 'ORA-01422: exact fetch returns more than requested number of rows
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.
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".
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms