Skip navigation

Following steps demonstrate how to read data from the a .CSV file which can be further passed to a Services Request (Form Service, Data Service or a custom database connector).


Purpose –

We will be creating the connector for FTP server and read a CSV file which has AddressBook Numbers.

The output of this will be sent to a Form Service request which will return AddressBook Number, Alpha Name and Search Type for that AB number from P01012. Also, we will be using iterate over to read each row from the CSV file


Step 1 -

Login into OrchestratorStudio and Click on the Tools link


Step 2 -

Select Connections where we will be defining the FTP server details



Step 3 -

Enter your FTP server details. Please make sure to validate the FTP server details using tools like - WinSCP



Step 4 -

Click on Service Request and select Connector option. This will be used for defining CSV file details and selecting the field’s data to be imported.

a) Select the FTP connection name from the drop-down which we had created in the previous step.

b) Enter the Source file name which is located in your FTP Server locations share path example. /E920

c) Check Import CSV as Array and CSV have Headers options.

The Import CSV as Array option helps to read all the rows from the CSV file and using the header it becomes easy to recognize the fields.


d) Define Data Set variable name. This is similar to the concept of the array which will hold the value for a row from the CSV file and will be used for iteration purpose in further steps.

e) Upload your CSV file as a sample/reference to create a variable name for each of the row headers/columns


Save this Connector Service Request.


Shown below is the Structure of ABN1.csv file:

Step 5 -

Creating Form Service Request

Create a Service Request which will take input (AddressBook number) from the CSV file and will return associated AddressBook Number and Alpha Name from P01012 Application


Return Fields –



Step 6 -

Now we need to map the Connector and Form Service to an Orchestration. Click on the navigation panel and select Orchestration.


Enter the name of the Orchestration and under Orchestration steps, select Service Request and click on the + icon.

Click on the drop-down and select the previously created FTP connector.

Now, we will add Form Service to Orchestration as Step After the connector using the same steps.

Orchestration after adding Connector and Form Service Request.

If you highlight the Form Request, orchestration will show the required inputs to the form request.

Now, we will map the output from the connector to the Form Service Request.

Here AB is data set variable define under the Connector service and Address Number is a variable name which holds AB number for the CSV row.

In order to read all the rows (one by one) from the CSV, we will select the Data set variable (AB) from iterate over option.


Orchestration Output –

Highlight the Form Service Request and Click on Define Output button.

Select the Output fields -


Save this Orchestration.


Testing Orchestration using Orchestrator Client-

There is no manual input for this Orchestration as it will read the AddressBook number from the CSV and return the Alpha Name, Search Type and AddressBook Number.


Results -

Purpose - You have created an Orchestration and now would like end users to be able to run that using E1Page whenever they login into EnterpriseOne.


Prerequisite -

a.  knowledge of HTML and JavaScript.

b.  A working/tested Orchestration.

For the demonstration purpose, I have a created an Orchestration “AA_ORCH_P0092" which simply takes input and create a record in User Profile - P0092 application


Here is the screenshot when this Orchestration using Orchestration Client.

Result -

When I run above Orchestration, it creates UserID in P0092 application.


EnterpriseOne HTML Server comes with a library named e1pagehelper.js which includes callAISOrchestrationV2 OR callAISOrchestration functions for calling Orchestration.

We will be calling either of the functions for invoking Orchestration from HTML Page i.e. E1Page


Step#1 - Create Folder to keeping HTML file.

Step#2 - Create a file home.html under this folder.


Step#3 -

Code for home.html -





<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">






   <script src="../e1pagehelper.js" type="text/javascript"></script>


var input =


"Role" :"Sysadmin",

"User ID": "abc"




    <button onclick="javascript:callAISOrchestrationV2('AA_ORCH_Test', input,


function (response)





)">Run Orchestrations</button>  






Explanation -


1. home.html page will have a Button called “Run Orchestration” which will invoke Orchestration.


2. callAISOrchestrationV2 Function in present under e1pagehelper.js, hence we need to include the same in the home.html file.


<script src="../e1pagehelper.js" type="text/javascript"></script>


3. JSON Input – I have User ID and Role in JSON format.



"Role" :"Sysadmin",

"User ID": "abc"



You may also create a text box to take input from Users.


4. As a test purpose, I have added an alert message box to capture and show the response returned by the function. This also indicates that our function is getting executed




Preparing for E1Page


1.  Create a ZIP file with home.html



2.  Login into WebClient and select Manage Content > Classic Pages



3.     Upload the E1Page Zip file



4. Open P98220U ( Work with User Defined Objects) application and approve/share E1Page record



1.       Logout and re-login. This time you will see a new E1Page with Button.





g     Click on the button to invoke Orchestration. This will also show an alert message box with a response from the function.




1.       Open application P0092 and verify if the User ABC record got created.



In the Orchestrator Studio, you can create a Connector Service Request to Call external REST Service.


In this blog, we will be using a free REST API for Currency Conversion from


Sample Input -


v6/Convert API takes input as FromCurreny_ToCurency


Sample Output -

















Using Orchestrator Studio, we will be calling v6/convert REST API and pass parameters at the run-time to get the output.


Step# 1 - Create Connector


Login into Orchestrator Studio and click on Tools option.




Click on Connectors -




here we need to fine Connection properties for external REST system and save it -


Type - External REST

Endpoint -


Note - This API doesn't require authorization. if required Authorization can be defined under the Security tab.

Also, if you are using a proxy server then it can be defined under the Proxy tab.



Step#3-  Creating Connector Service.


Click on Service Request and select Connector -



Here define the connector details and select the connection name which we have defined in previous steps.

Also, define the parameter to the REST API.

Example - here q is the parameter for this API



You can also quickly test this service using the Test button.




Test result Output -



Step 3# Creating Orchestration and map input variable.


Now, we will map the created Connector Service to Orchestration and map variables.




Click on the drop-down and select the previously defined Connector Service.






Notice the Variable ${From_To} is displayed as an input to Connector Service Request -




Now, define Orchestration Input and map to the variable from Connector Service Request.




Testing -


Login into Orchestrator Client and select your Orchestration from the drop-down list.

Orchestration input variable will be displayed under INPUTS.


Example - Enter the value as usd_inr for converting currency from USA to India.


Reference -


check for the available list of countries and currency.

JD Edwards EnterpriseOne Tools Orchestrator Guide

Premier Support for Oracle JD Edwards is extended through at least 2030, reinforcing our commitment to customers and product innovation. A stable and predictable long-term support policy enables customers to maximize and expand their existing investments with ample time for future planning. Read this FAQ for answers to common questions around Oracle policy on Premier Support for Oracle JD Edwards.


Oracle Premier Support for EnterpriseOne – FAQ


For more information on Continuous Innovation releases, please visit the JD Edwards EnterpriseOne Releases page.

JDE IOT OrchestratorStudio is a independent ADF Application which deployed on Weblogic Server and access via a URL.


OrchestratorStudio helps in designing IOT Orchestration XMLs which includes CrossReferences,Orchestrations,Rules,ServiceRequests,WhiteLists


Step 1.  Download and install ADF Runtime. Refer KM document - E1: ADF: Installation of ADF Runtime for IoT (Doc ID 2126884.1)


Step 2.  Create new Weblogic Domain with ADF Runtime and EM (Enterprise Manager Console).


Step 3.  Download and extract OrchestratorStudio related files. Follow KM document - E1: IOT: How To Download Orchestrator Studio Files (Doc ID 2109323.1)


Step 4. Login into Weblogic Admin console.


Step 4.1 - Click on Lock & Edit and navigate to Environments >Servers Click on NEW button for creating J2EE container.


Step 4.2 - Enter J2EE container name and valid/available port number and click on Finish



Note- Do not start J2EE container at this point


Step 5. Login into Weblogic EM console (http://<servername><port>/ ) , Select J2EE Container name and click on "Apply JRF Template".


   Confirmation message -



Step 6. Start Command prompt and navigate to WebLogic server path - C:\Oracle\Middleware\Oracle_Home\wlserver\server\bin and run setWLSEnv.cmd to setting-up WLS Environment variable.




Step 8. Navigate to folder where you have extracted OrchestratorStudio related files. this folder folder should have following files -


1. OrchestrationStudio.ear


3. build.xml


Step 9. Edit file using text editor and update Weblogic Server host name , WLS Admin Server port, J2EE container name and save it.


Snap14.jpg - Weblogic Server Host name

  weblogic.server.port - Weblogic Server's Admin Sever port

weblogic.deploy.targets - J2EE container name where OrchestratorStudio Application will be deployed.



Step 10. Now navigate to OrchestratorStudio folder using same command window ( this will keep WLS environment path available for the session ).


Step 11. Run command ant deploy



   Enter WebLogic Server's Admin Username and password when prompted on screen.



   Deploy Script will connect to WebLogic Admin console and will deploy OrchestrationStudio.ear file to defined J2EE container.



Step 12.  Login into Weblogic Admin console and start J2EE container for OrchestrationStudio.


Step 13. Once J2EE container is started , navigate to "Deployment" section and you should have below structure.-



Step 14. Now expand OrchestrationStudio and select Testing tab  to get URL for deployed OrchestrationStudio application -



Access OrchestrationStudio using URL - http://<ServerName/IP>:<port>/OrchestratorStudio/faces/index.jsf


Note - You may need to append  /faces/index.jsf at the end of URL




Step 15. Enter AIS Server URL under OrchestrationStudio. it will be used for Login and integrating AIS Test Client within OrchestrationStudio.



                          JDE IOT- OrchestratorStudio


Filter Blog

By date: By tag:

Welcome to the My Oracle Support Community! We highly encourage you to personalize your community display name to make your activity more memorable. Please see for instructions.