My Oracle Support Banner

ARI_SELF_REGISTRATION_PKG.UpdateRegistrationTable Raises Error, Prevents Employee Registration (Doc ID 1544898.1)

Last updated on FEBRUARY 13, 2019

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



Changes

 

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
Changes
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.