My Oracle Support Banner

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 later
Information 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


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