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 OCTOBER 12, 2016

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

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