Customer Form, Address Error: Setting the Primary Checkbox Raises ORA-01422: exact fetch returns more than requested number of rows.
Last updated on MARCH 31, 2017
Applies to:Oracle Receivables - Version 188.8.131.52 to 184.108.40.206 [Release 11.5.10]
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
Million Knowledge Articles and hundreds of Community platforms