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
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!