Approving Change To Existing Address In iSupplier Portal Errors: ORA-20002: 398: Invalid user name
(Doc ID 2912104.1)
Last updated on NOVEMBER 28, 2022
Applies to:
Oracle iSupplier Portal - Version 12.2 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2 version, Supplier Admin Issues
Approving Change to existing address gives error in Supplier Address Change Requests.
ERROR
-----------------------
Error Page
You have encountered an unexpected error.
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-20002: 398: Invalid user name 'IS*******@GMAIL.COM'
ORA-06512: at "APPS.POS_PROFILE_CHANGE_REQUEST_PKG", line 492
ORA-06512: at "APPS.WF_DIRECTORY", line 3365
ORA-06512: at "APPS.WF_DIRECTORY", line 3481
ORA-06512: at "APPS.WF_CORE", line 318
ORA-06512: at "APPS.WF_CORE", line 315
ORA-06512: at "APPS.WF_DIRECTORY", line 3429
ORA-06512: at "APPS.WF_DIRECTORY", line 3357
ORA-06512: at "APPS.POS_PROFILE_CHANGE_REQUEST_PKG", line 180
ORA-06512: at line 1
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:998)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:783)
at oracle.apps.pos.request.webui.PosJustificationCommentsCO.processFormRequest(PosJustificationCommentsCO.java:144)
. . . . .
## Detail 0 ##
java.sql.SQLException: ORA-20002: 398: Invalid user name 'IS*******@GMAIL.COM'
ORA-06512: at "APPS.POS_PROFILE_CHANGE_REQUEST_PKG", line 492
ORA-06512: at "APPS.WF_DIRECTORY", line 3365
ORA-06512: at "APPS.WF_DIRECTORY", line 3481
ORA-06512: at "APPS.WF_CORE", line 318
ORA-06512: at "APPS.WF_CORE", line 315
ORA-06512: at "APPS.WF_DIRECTORY", line 3429
ORA-06512: at "APPS.WF_DIRECTORY", line 3357
ORA-06512: at "APPS.POS_PROFILE_CHANGE_REQUEST_PKG", line 180
ORA-06512: at line 1
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Purchasing Super User > Supply Base > Suppliers
2. Click in right frame menu > click Supplier Address Requests (10)
3. Supplier Profile Change Requests > Select "Change to Existing Address > Click Approve
4. Enter Justification > Click Submit
5. Error occurs
Changes
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 |