Exception When Trying to Invite Same Supplier to Register With Different Email Address (Doc ID 1999957.1)

Last updated on MARCH 15, 2022

Applies to:

Symptoms

On : 12.1.3 version, Supplier User Issues

When attempting to Invite Same Supplier twice with a different email address getting below exception

Expectation is application should not allow to Invite same Supplier again and display meaning ful error message


ERROR
-----------------------
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-20002: 397: Duplicate user regnewsupplier22@test.com ('regnewsupplier2')
ORA-06512: at "APPS.WF_DIRECTORY", line 1767
ORA-06512: at "APPS.POS_SPM_WF_PKG1", line 3002
ORA-06512: at "APPS.POS_REQUEST_UTILS_PKG", line 24
ORA-06512: at line 1

at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:996)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:133)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:799)
at oracle.apps.pos.supplier.webui.SuppRegisterSupplierCO.processFormRequest(SuppRegisterSupplierCO.java:191)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:827)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login into Supplier Management Administrator
2. Click on Register new Supplier, enter supplier name - “regnewsupplier2” with email address - regnewsupplier21@test.com
3. Now try to Register supplier again with supplier name - “regnewsupplier2” with email address - regnewsupplier22@test.com

Exception occurs and exception shows that duplicate supplier

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.