My Oracle Support Banner

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

Last updated on SEPTEMBER 13, 2016

Applies to:

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

Symptoms

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

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!


In this Document
Symptoms
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


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