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 FEBRUARY 06, 2019

Applies to:

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

Purpose

Starting with EnterpriseOne Tools Release 8.98.3.0 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 Document 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 8.98.3.0 and later.

For older releases refer to Document 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.

Scope

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

Details

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
Purpose
Scope
Details
 Pre-requisites
 Overview 
 Example
 Troubleshooting
References

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