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.
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:
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