My Oracle Support Banner

E1: ORCH: How to Download and Send by Email a Media Object File Using an Orchestration in Jd Edwards Enterpriseone When Unable to Use an Attachment to Message Request (Doc ID 2832757.1)

Last updated on MARCH 13, 2024

Applies to:

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


Disclaimer:  This document is provided to assist customers trying to implement Media Object download prior to TR 9.2.6.x.  It is only an example and not a supported solution. 

                    The solution includes script languages which are not directly supported by JDE engineers and is provided only as a guideline where customer's will use their own customization using their preferred scripting language.

This solution provides the steps required to download a media object file to temporary folder used by AIS server and send the same file through email. The present solution can be extended to download and deliver multiple files, but the present document provides only a valid proof of concept. The present solution is applicable to AIS version up to 9.2.5.X as in version 9.2.6.X (Release 22), Media Object files could be downloaded using Attachments requests and the Message request includes also the option to attach to the email a Media Object file. This solution also applies in later Tools Releases if media objects are not stored in the database (in F98MODAT), as this is a prerequisite for using media object attachment to message requests.

To implement this solution, it is required to use two custom requests: one for downloading the Media Object file and one for sending out the email with the downloaded file attached to the email.

The customer requests shown in this document are based on Groovy script and on JRuby script. JRuby scripts are available starting with tools release

The below Orchestrations examples are using two custom requests which could be combined into one custom request. However, the examples where given in such way so that the included custom requested could be used separately, within other Orchestrations.


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
 A. Download and send by email a Media Object file using an Orchestration making use of Groovy based custom requests
 B. Download and send by email a Media Object file using an Orchestration making use of JRuby based custom requests

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