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 JANUARY 28, 2022
Oracle iReceivables - Version 12.1.3 and later
Information in this document applies to any platform.
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.