My Oracle Support Banner

E1: XMLP: How to Setup Dynamic Subject and Body for E-mail Delivery using Embedded BI Publisher with in JDE? (Doc ID 1103153.1)

Last updated on AUGUST 18, 2021

Applies to:

JD Edwards EnterpriseOne Tools - Version 8.98 and later
Information in this document applies to any platform.


Starting with EnterpriseOne Tools Release and ESU containing enhancement <BUG 11019115> for EnterpriseOne 9.0 and <BUG 11024413> for EnterpriseOne 8.12, it is possible to deliver BI Publisher reports via e-mail containing a custom subject and body. According to the instructions in the Guide Doc ID 1086540.1 JD Edwards EnterpriseOne Tools Release 8.98 Update 3 Enhanced Embedded BI Publisher Email Delivery Options it is possible to define a custom subject and body that will be used every time the report definition runs.

The subject and body are defined by a custom data item (glossary group 'E') and values that are inserted in placeholders defined in the message. These values are passed via the data structure associated to the custom data item. The actual values are defined by clicking the button "Define Values" in the Report Definition/Burst and Delivery form (P95620).

However, unless these values are manually modified between different runs of the same report definition, the subject and body of the e-mail will be all the same. Similarly, if using burst, all bursted emails will have the same subject and body.  

It is possible to dynamically change the e-mail subject or body using substitution parameters that take value from Source XML. 

This document contains a step by step example of how to setup custom e-mail subject and body in reports delivered by embedded BI Publisher for EnterpriseOne 8.12 and later, with tools release and later.

For older releases refer to Doc ID 754249.1 E1: XMLP: How to Change E-Mail Delivery Text for information about how to change the Subject and Body text of the e-mail.


 This document is intended for the JDE Report Developer and System administrators who are responsible for customizing the Report definition email delivery 


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

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