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
Last updated on JUNE 22, 2016
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.
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 :
Then you are receiving the following error message :
XML/BI Publisher Version : 5.6.3
Updating request description
Retrieving XML request information
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 ``>'' at position 3
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms