ARI_SELF_REGISTRATION_PKG.UpdateRegistrationTable Raises Error, Prevents Employee Registration
Last updated on SEPTEMBER 06, 2017
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
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