GMSAWEAW ORA-01422: FORM ERROR WHEN TWO RECORDS IN HZ_CUST_SITE_USES_ALL (Doc ID 2034007.1)

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.

Symptoms

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.

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