In iSupplier Portal, Error Occurs When Email Address Has Domain Extension Greater Than Four Characters - ORA-20001 ORA-2002 - ORIG_SYSTEM_ID=NULL Has Been Detected In FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT (Doc ID 2920891.1)

Last updated on JUNE 05, 2023

Applies to:

Symptoms

When attempting to create a supplier user, the following error occurs if the email address has @x.GROUP instead of @x.COM

ERROR
-----------------------
## Detail 0 ##
java.sql.SQLException: ORA-20001: Oracle error -20001: ORA-20001: Oracle error -20002: ORA-20002: [WF_NO_USER] NAME=RXXXXXXXXXXX ORIG_SYSTEM=NULL ORIG_SYSTEM_ID=NULL has been detected in FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT. has been detected in FND_USER_RESP_GROUPS_API.UPLOAD_ASSIGNMENT.
ORA-06512: at "APPS.POS_USER_ADMIN_PKG", line 247
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at "APPS.FND_USER_RESP_GROUPS_API", line 29
ORA-06512: at "APPS.FND_USER_RESP_GROUPS_API", line 1047
ORA-06512: at "APPS.POS_USER_ADMIN_PKG", line 227
ORA-06512: at "APPS.POS_USER_ADMIN_PKG", line 290
ORA-06512: at line 1


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into Supplier User Management responsibility.
2. Search for a particular supplier.
3. From the Update <Supplier>: Organization page, click on the Contact Directory link.
4. From the Update <Supplier>: Contact Directory page, click on the Create button.
5. From the Create Contact page, enter the first name, last name, and email address RXXXX.WXXXXX@GXX.GXXXX.
6. Check the 'Create User Account for this Contact' and the 'iSupplier Portal Full Access' checkboxes.
7. Click on the Apply button. The following error message is displayed:

You have encountered an unexpected error. Please contact your System Administrator for assistance.

Changes

None

Cause

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