Error when updating the Salesperson/Payment terms in the Customer Form

(Doc ID 1674977.1)

Last updated on FEBRUARY 23, 2015

Applies to:

Oracle Trading Community - Version 11.5.10.2 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.

Symptoms

Attempting to update the fields Salesperson / Payment Terms, in the BILL_TO business purpose section of the Customer form, and receive the following error:

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

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