Vendor Name With ':' Is Not Being Allowed In The System
(Doc ID 2872069.1)
Last updated on MAY 25, 2022
Applies to:
Oracle Supplier Lifecycle Management - Version 12.1.3 to 12.2.11 [Release 12.1 to 12.2]Information in this document applies to any platform.
Symptoms
On : 12.2.5 version, Supplier Profile Management
Vendor Name with ':' is not being allowed in the system
During Supplier registrations, the vendor name with ':' (Colon) is being allowed by the system. But after category manager approval when the supplier is being created in the system, the following error occurs:
ERROR
-----------------------
java.sql.SQLException: ORA-20002: 4001: 'ADHOC_USER_B*** ****** DBA: A**** S***_03302022_1325271980993211' is an invalid internal name because it contains a colon. For this particular role, if the name contains a colon, it has to be 'WF_LOCAL_USERS:0' . ORA-06512: at "APPS.WF_DIRECTORY", line 1955 ORA-06512: at "APPS.WF_DIRECTORY", line 1863 ORA-06512: at "APPS.WF_CORE", line 318 ORA-06512: at "APPS.WF_CORE", line 315 ORA-06512: at "APPS.WF_DIRECTORY", line 1627 ORA-06512: at "APPS.WF_DIRECTORY", line 1936 ORA-06512: at "APPS.POS_SPM_WF_PKG1", line 3004 ORA-06512: at "APPS.POS_REQUEST_UTILS_PKG", line 24 ORA-06512: at line 1
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Supplier Management > Suppliers
2. Choose Operating Unit from LOV
3. Suppliers: Register New Supplier > Fill out required fields
4. Supplier name = TEST_COLON:ISSUE
5. New Supplier Request > Actions LOV: Send to Category Manager Approval
6. Popup confirming Request has been sent to Category Manager
7. Log in as Category Manager to Approve
8. New Supplier Request > Actions LOV: Category Manager Approve
9. Once approved the reported error occurs
Note: Any references to user names, personnel or companies are fictitious and not intended to reflect actual names, places or companies
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 |
References |