My Oracle Support Banner

Output Customer Data Collection Test Gives Error:The View AR_CUSTOMERS_V Returns More Than One Row (Doc ID 265202.1)

Last updated on JANUARY 02, 2025

Applies to:

Oracle Receivables - Version 11.5.0 and later
Information in this document applies to any platform.
Oracle Receivables - Version: 11.5
This problem can occur on any platform.
ARXCUDCI - Customers
ARCustomerInfo115.sql
Customer Data Collection (Release 11.5)

Symptoms

Output of Customer Data Collection Test errors with:

ERROR - The view AR_CUSTOMERS_V returns more than one row
( ORA-01422: exact fetch returns more than requested number of rows ).

You have entered your customer as 'person'.

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.