Customer Form, Address Error: Setting the Primary Checkbox Raises ORA-01422: exact fetch returns more than requested number of rows.

(Doc ID 462809.1)

Last updated on MARCH 31, 2017

Applies to:

Oracle Receivables - Version 11.5.10.0 to 11.5.10.3 [Release 11.5.10]
Information in this document applies to any platform.
Form:ARXCUDCI.FMB - Customers


Symptoms

When checking the Primary check box for a Ship To Business Purpose, the following error is raised:

APP-AR-96282: Error: The following SQL Error occurred:
ORA-01422: exact fetch returns more than requested number of rows.


Steps To Reproduce:

  1. Responsibility: Receivables Manager
    Navigation: Customers > Standard
  2. Query  for an existing Customer
  3. Navigate to the Customer Address form
  4. In the Business Purpose tab, check the Primary check box for the Ship to and attempt to save. The error is raised. This does not happen to all customer address records.



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