My Oracle Support Banner

Unable to Generate E-Mails From Bursting Using an Alias as an Email such as "Mr. Abc'def <X@Y.Z>" And/Or a Quote in the Subject (Doc ID 1112344.1)

Last updated on DECEMBER 23, 2023

Applies to:

BI Publisher (formerly XML Publisher) - Version 5.6.3 to 5.6.3 [Release 5]
Information in this document applies to any platform.

Symptoms


You are using Oracle applications release 11i or R12  with BI Publisher 5.6.3.

You want to use the busting feature for sending mails but you also would like

- to use quote in the subject of the mail,

- the recipient to see in their mailbox that the e-mail comes from a generic name (Alias) , the real e-mail address should only be seen when clicking or responding .This Alias can have a quote.

When trying to implement this you are facing the following issue :

1) The problem with the subject is: When sending a letter with a single quote mark in the subject, everything on the left side from the quote mark disappears.
For example :
If the subject should be "TEST's (123)", you obtain an e-mail with subject "s (123)".
If the subject should be "TEST 'test'  (123)", you obtain an e-mail with subject " (234)".)
   
2) The problem with the Alias in e-mail address is : The  program complains about a ``>'' which is used for providing the email after the alias
For example :
ABC first.lastname@server
Then you are receiving the following error message :

XML/BI Publisher Version : 5.6.3
Updating request description
Retrieving XML request information
Preparing parameters
Set Bursting parameters..
Start bursting process..
[060209_022002562][oracle.apps.xdo.batch.DeliveryHelper][EXCEPTION] javax.mail.internet.AddressException: Illegal semicolon, not in group in string ``&gt;'' at position 3
at javax.mail.internet.InternetAddress.parse(InternetAddress.java:712)
at javax.mail.internet.InternetAddress.<init>(InternetAddress.java:61)
at oracle.apps.xdo.delivery.smtp.SMTPDeliveryRequestHandler.submitRequest(SMTPDeliveryRequestHandler.java:710)
......

Of Course you can workaround this problem, if you remove all the quote marks from the subject and using a "simple" e-mail address, but this is not an acceptable solution for you.

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


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