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:
Oracle iSupplier Portal - Version 12.2.11 to 12.2.5 [Release 12.2]Oracle Workflow - Version 12.2.1 and later
Information in this document applies to any platform.
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
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
Symptoms |
Changes |
Cause |
Solution |
References |