Modify Customer Ship-To Descriptive Flexfield (DFF) Error - ORA-01422: Exact Fetch Returns More Than Requested Number of Rows
Last updated on JULY 12, 2017
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.
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