How to Change E-Mail Delivery Text

Goal
Solution

Goal

When sending an e-mail using the Report Definition delivery options, the e-mail contains a generic text.  Is there a way to change this text to be specific to the customer's need?

Solution

The Subject and Body Text of the e-mail can be changed by changing the data dictionary items.

 

951S - Report Definition email subject text
           Will change the subject of the XMLP RD delivery e-mail.


951T - Report Definition email attachment text
            Will change the text in the body of the e-mail.

 

To change these data dictionary items:

  1. Enter P92002 - Data Dictionary Glossary Items
  2. Search for and Select the appropriate Data Item
  3. Select the Item Glossary tab
  4. Change text as required

Changes may need to be deployed. Refer to Deploying Data Dictionary Changes for more information about how to deploy data dictionary changes. If the Data Dictionary is environment specific you will need to promote and deploy these changes to all environments.

Note: the ability to dynamically set e-mail subject and body is available in EnterpriseOne 8.12 and later, with tools release 8.98.3.0 and later. Refer to How to Setup Dynamic Subject and Body for E-mail Delivery? for more information.

 

It is also possible to somewhat customize the From field of the e-mail address sent by the BI Publisher engine. The From address can be changed from the server JDE.INI, the system looks for PSFT_SYSTEM in the JDEMAIL section.  An example would be:

[JDEMAIL]
...
Rule3=110|DEFAULT|PSFT_SYSTEM=PSFT_System@oracle.com

change to:

[JDEMAIL]
...
Rule3=110|DEFAULT|PSFT_SYSTEM=mymailserver@mycompany.com

Keep in mind that this is a global setting affecting all emails sent by the system and will only take effect after bouncing services.