GMSAWEAW ORA-01422: FORM ERROR WHEN TWO RECORDS IN HZ_CUST_SITE_USES_ALL
Last updated on APRIL 11, 2017
Applies to:Oracle Grants Accounting - Version 12.1.3 and later
Information in this document applies to any platform.
When searching for an award which exists in GMS_AWARDS_ALL an error is displayed on screen ORA-01422 Exact Fetch returns more than requested number of rows. The award cannot be accessed within the form.
With queries it seems that there are two records in HZ_CUST_SITE_USES_ALL that throws the error.
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