ORA-20002: 410: Invalid email address for the user/role 'FDA_IPP_UAR_TEAM' (Doc ID 2884864.1)

Last updated on AUGUST 23, 2023

Applies to:

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

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