Modify Customer Ship-To Descriptive Flexfield (DFF) Error - ORA-01422: Exact Fetch Returns More Than Requested Number of Rows (Doc ID 1608024.1)

Last updated on JULY 12, 2017

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

In R12.1.3:

Attempting to update a Customer Ship-To address and receive the following error:

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


Steps to Reproduce:
Responsibility:  Receivables
Navigation: Customers > Customers
Search for the Customer (for this example: 75767)
Click on Details on the Account section
Click on Details on the Site section
Select the Business Purposes tab and select the Ship To purpose.
Modify one descriptive flexfield value (ie. Stupéfiants)
Click the Apply button - The error appears.

The issue only happens to this one customer.

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