My Oracle Support Banner

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

Last updated on MARCH 21, 2019

Applies to:

Oracle iSupplier Portal - Version 12.1.3 and later
Information in this document applies to any platform.


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

oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-20002: 397: Duplicate user ('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(
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(
at oracle.apps.pos.supplier.webui.SuppRegisterSupplierCO.processFormRequest(
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(

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 -
3. Now try to Register supplier again with supplier name - “regnewsupplier2” with email address -

Exception occurs and exception shows that duplicate supplier


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

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