Customer Form, Address Error: Setting the Primary Checkbox Raises ORA-01422: exact fetch returns more than requested number of rows.
(Doc ID 462809.1)
Last updated on JULY 24, 2018
Applies to:Oracle Receivables - Version 18.104.22.168 and later
Oracle Trading Community - Version 22.214.171.124 and later
Information in this document applies to any platform.
Form:ARXCUDCI.FMB - Customers
When checking the Primary check box for a Ship To Business Purpose, the following error is raised:
APP-AR-96282: Error: The following SQL Error occurred:
ORA-01422: exact fetch returns more than requested number of rows.
Steps To Reproduce:
- Responsibility: Receivables Manager
Navigation: Customers > Standard
- Query for an existing Customer
- Navigate to the Customer Address form
- In the Business Purpose tab, check the Primary check box for the Ship to and attempt to save. The error is raised. This does not happen to all customer address records.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!