My Oracle Support Banner

Self Registration Error from Actions Menu - ORA-20002 ORA-06512 (Doc ID 1540596.1)

Last updated on FEBRUARY 22, 2019

Applies to:

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


Attempting to select Self Registration from the Actions menu in Advanced Collections and receive the following error:

Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = java.sql.SQLException
ORA-20002 Encountered During Execution of Rule Function 'ARI_SELF_REGISTRATION_PKG.UpdateRegistrationTable'
ORA-06512: at "APPS.WF_EVENT", line 1181
ORA-06512: at "APPS.UMX_REGISTRATION_PVT", line 151
ORA-06512: at "APPS.UMX_REGISTRATION_PVT", line 201
ORA-06512: at "APPS.UMX_REGISTRATION_PVT_W", line 77
ORA-06512: at line 1 ;

Steps to Reproduce:
Select the Customer Account with a Contact Email Address
Go To:  Actions > Self Registration


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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.