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 MARCH 21, 2023

Applies to:

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 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 8.98.3.0 and later.

Scope

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

Details

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