Cannot Delete Contact Because of Contact Email Validation (Doc ID 2542593.1)

Last updated on SEPTEMBER 11, 2020

Applies to:

Goal

On : NA version, Accounts, Contacts, Households

Users cannot delete contacts.

Existing validation scripts(Before Update trigger and Before Insert trigger):

def regex =/(?i)^([\w-]+(?:\.[\w-]+)*)@((?:[\w-]+\.)*\w[\w-]{0,66})\.([a-z]{2,6}(?:\.[a-z]{2})?)$/
 def email = getAttribute('ListEmailAddress');
 def EmailCollection = Email

 while(EmailCollection.hasNext())
 {
 def emailRec = EmailCollection.next()
 emailRec.EmailAddress=email
 if (!(email.matches(regex))){
 throw new oracle.jbo.ValidationException("Please type the email in the appropriate format (e.g. someone@someone.com) -> " + emailRec.EmailAddress)
 }
 }

When script is removed, users are able to delete Contacts.
 

Solution

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