ARI_SELF_REGISTRATION_PKG.UpdateRegistrationTable Raises Error, Prevents Employee Registration

(Doc ID 1544898.1)

Last updated on SEPTEMBER 06, 2017

Applies to:

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

Symptoms

ARI_SELF_REGISTRATION_PKG.UpdateRegistrationTable raises an error and prevents Employee Registration.  We are not using iReceivables Self Registration process.

Following the application on patch 14307553 a new subscription is created on Event oacle.apps.fnd.umx.startaccountrequestwf

The subscription is for ARI_SELF_REGISTRATION_PKG.UpdateRegistrationTable and is active.

When an unregistered employee clicks the standard 'Register Here' link, enters their information and press submit, the page raises an unhandled exception:

oracle.apps.fnd.framework.OAException: java.sql.Exception: ORA-20002: 3825: Error '-20001 - ORA-20001: ' encountered during execution of Rule Function 'ARI_SELF_REGISTRATION_PKG.UpdateRegistrationTable' for event 'oacle.apps.fnd.umx.startaccountrequestwf' with key ...
ORA-06512: at "APPS.WF_EVENT", line 1181
ORA-06512: at "APPS.UMX_REGISTRATION_PVT", line 151
ORA-06512: at "APPS.UMX_REGISTRATION_PVT_W", line 201
ORA-06512: at "APPS.UMX_REGISTRATION_PVT_W", line 77
ORA-06512: at line 1



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