Customer Form, Address Error: Setting the Primary Checkbox Raises ORA-01422: exact fetch returns more than requested number of rows.
Last updated on MAY 16, 2018
Applies to:Oracle Receivables - Version 220.127.116.11 and later
Oracle Trading Community - Version 18.104.22.168 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.
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