My Oracle Support Banner

ARI_SELF_REGISTRATION_PKG.UpdateRegistrationTable Raises Error, Prevents Employee Registration (Doc ID 1544898.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.


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




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.