ORA-20002: 410: Invalid email address for the user/role 'FDA_IPP_UAR_TEAM'
(Doc ID 2884864.1)
Last updated on DECEMBER 07, 2024
Applies to:
Oracle Workflow - Version 12.2.9 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.9 version, Workflow Administration
ACTUAL BEHAVIOR
---------------
Unable to create workflow roles for email addresses with quotes (Den.O'Gotxxx@test.gov)
EXPECTED BEHAVIOR
-----------------------
To be able to create workflow roles for email addresses with quotes (Den.O'Gotxxx@test.gov) as prior to the application of the noted patch.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Attempt to create workflow roles for email addresses with quotes (Den.O'Gotxxx@test.gov)
WF_DIRECTORY.SetAdHocRoleAttr(role_name=>l_role_name ,email_address =>'Den.O'Gotxxx@test.gov');
It will fail with following error message.
Error at line 2
ORA-20002: 410: Invalid email address for the user/role 'FDA_IPP_UAR_TEAM'.
ORA-6512: at "APPS.WF_DIRECTORY", line 4126
ORA-6512: at "APPS.WF_DIRECTORY", line 3959
ORA-6512: at "APPS.WF_CORE", line 318
ORA-6512: at "APPS.WF_CORE", line 315
ORA-6512: at "APPS.WF_DIRECTORY", line 3806
ORA-6512: at "APPS.WF_DIRECTORY", line 4107
ORA-6512: at line 50
ORA-6512: at line 50
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, the customer is unable to create workflow roles for email addresses with quotes (Den.O'Gotxxx@test.gov) in prod.
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 |
Cause |
Solution |
References |