Vendor Name With ':' Is Not Being Allowed In The System (Doc ID 2872069.1)

Last updated on MAY 25, 2022

Applies to:

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

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