My Oracle Support Banner

Adding an Additional Customer Account in Self Registration Error - ORA-01422: Exact Fetch Returns More Than Requested Number of Rows ORA-06512 (Doc ID 1901330.1)

Last updated on MAY 01, 2018

Applies to:

Oracle iReceivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 + March 2013 RPC

You are attempting to add another Customer Account to a user and receive the following error:

## Detail 0 ##
java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APPS_APPLPREP.ARI_SELF_REGISTRATION_PKG", line 2716

Steps to Reproduce:
Responsibility:  External iReceivables
Navigation:  Request Additional Access > Review Details
Receive a Java error

Due to this issue, users cannot use self registration to add access to other customer accounts.

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.