ARI_SELF_REGISTRATION_PKG.UpdateRegistrationTable Raises Error, Prevents Employee Registration
(Doc ID 1544898.1)
Last updated on JANUARY 28, 2022
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!