My Oracle Support Banner

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 JANUARY 16, 2020

Applies to:

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


In R12.1.3:

Attempting to update a Customer Ship-To address and receive the following 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.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.