My Oracle Support Banner

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 JULY 24, 2018

Applies to:

Oracle Receivables - Version 11.5.10.0 and later
Oracle Trading Community - Version 11.5.10.3 and later
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.



Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.