JDE Orchestrator: различия между версиями

Материал из JD Edwards E1
Перейти к навигации Перейти к поиску
Строка 285: Строка 285:
 
::* [https://support.oracle.com/epmos/faces/DocumentDisplay?id=2913018.1 E1: ORCH: What is the Purpose of the Trace Step button in Orchestration Monitor? [Updated: 12/09/2022]
 
::* [https://support.oracle.com/epmos/faces/DocumentDisplay?id=2913018.1 E1: ORCH: What is the Purpose of the Trace Step button in Orchestration Monitor? [Updated: 12/09/2022]
 
::* [https://support.oracle.com/epmos/faces/DocumentDisplay?id=2588133.1 E1: ORCH: Orchestrator Monitor Exception Alerts And Exception Records from F980060 Table [Updated: 04/02/2020]
 
::* [https://support.oracle.com/epmos/faces/DocumentDisplay?id=2588133.1 E1: ORCH: Orchestrator Monitor Exception Alerts And Exception Records from F980060 Table [Updated: 04/02/2020]
 +
 +
=== Orchestrator Connections ===
 +
* E1: ORCH: Orchestrator Connections Reference Center (Doc ID 2846191.2)
 +
; Connections How To and FAQ Documents
 +
:* E1: ORCH: Which Account is Used When an Orchestration is Running and Accessing External Network Folders. [Updated: 04/11/2024]
 +
:* E1: ORCH: How to Decrypt a REST Response Payload Returned From a Third Party [Updated: 10/18/2023]
 +
:* E1: ORCH: How to Create a Connector for Selecting Data From a Table Using a Variable with the EnterpriseOne Database (Read-only) DAD Connection [Updated: 08/03/2023]
 +
:* E1: ORCH: How To Delete Orchestration Connections From Orchestrator Studio User Interface [Updated: 05/23/2023]
 +
 +
=== Orchestrator Import/Export ===
 +
* [https://support.oracle.com/epmos/faces/DocumentDisplay?id=2725375.2 E1: ORCH: Orchestrator Import/Export Reference Center] (Doc ID 2725375.2)
  
 
=== Orchestrator B98ORCH ===  
 
=== Orchestrator B98ORCH ===  

Версия 17:58, 27 сентября 2024

  • Orchestrator Guide for Studio Version 9.2.4
  • Orchestrator Guide for Studio Version 8 and Prior

Orchestrator:

  • Компоненты Orchestration (Orchestration components) [Release 9.2.1];
  • Нотификация (Notifications) [Release 9.2.2];
  • График (Schedules) [Release 9.2.2];
  • Process Recorder [Release 9.2.2.4];

JD Edwards EnterpriseOne Orchestrator Studio

Orchestrations
[docs] [wiki]
Notifications
[docs] [wiki]
Workflows
[docs] [wiki]
Form Requests Data Requests Reports Watchlists Attachments
Connectors Logic Extensions Custom Requests Messages
Rules Cross References White Lists Schedules
Run
Orchestrations
JD Edwards
EnterpriseOne
Orchestrator
Monitor
Workflow
Monitor
Scheduler Import/Export Connections

Ссылки

Orchestrator Orchestrations

Orchestrator Orchestrations How To and FAQ Documents:

Orchestrator Notifications

Notifications How To and FAQ Documents

Orchestrator Workflows

Adding a Workflow (Release 9.2.6.4)

Starting with Tools Release 9.2.6.4, you can add workflows to your logic extensions. When you add a workflow to your logic extension, the Workflow panel is displayed at the right hand side of the design page that enables you to search for and add a workflow in the Workflow field. After you add the workflow in the Workflow field, the Key Data Structure and the Additional Data Structure sections are populated. You can click the Edit icon next to Key Data Structure and Additional Data Structure and map the parameters. Next to each required parameter the system displays the Incomplete Mapping (!) icon in red. You can click the Edit icon to open the Workflow Parameter Mapping window and complete the mappings for a required parameter. The Input fields are disabled for the required parameters.

To add a Workflow:

  • On the design page, hover over the location where you want to add the workflow and then click the + icon. Select Workflow from the Action menu. The system displays the Workflow panel on the right.
  • In the Workflow panel, enter the label and the description for the workflow.
  • In the Workflow field, click the Search icon to search for and select the required workflow from the Workflow List window. After you select the workflow, the Key Data Structure and Additional Data Structure sections are displayed to create the mappings. Next to each required parameter the system displays the Incomplete Mapping (!) icon in red.
  • Click the Edit icon next to Parameter Mapping and Additional Data Structure to open the Workflow Parameter Mapping window and complete the mappings as required.
  • Click the Close button.
  • Click Save. You can add the workflow parameters to the Data Structure tab and to the Variables tab from the Workflow Parameter Mapping window. Click the drop-down list next to the Name field and select the Add to Data Structure or Add to Variables or Add to Array (Release 9.2.7) option as required.
Links
Orchestrator Workflows How To and FAQ Documents

Orchestrator Form Request

Form Service Request How To and FAQ Documents

Orchestrator Data Requests

Data Request How To and FAQ Documents

Orchestrator Reports

Reports Request How To and FAQ Documents

Orchestrator Attachments

Attachments How To and FAQ Documents

Orchestrator Connector

In the Orchestrator Studio, you can create a connector service request to enable an orchestration to:

  • Invoke another orchestration or a notification on an AIS Server on another EnterpriseOne system in a multisite operation.
  • Invoke a REST service. Referred to as a REST connector, this connector enables outbound REST calls to external systems through an orchestration step. For example, an orchestration could make a REST call to a Cloud service and use the data in the response in subsequent orchestration steps.
  • You can also configure a REST connector to invoke REST services from your local AIS server. By using the Local AIS Call connection, you can run a REST service on the current AIS server by using the existing session established to run the calling orchestration
  • Connect to a database. Referred to as a database connector, this connector enables orchestrations to read from and write to non-JD Edwards databases using standard SQL protocol. The database must support JDBC. A database connector enables external databases to be the source of input for orchestrations. It also enables data that is not appropriate for transaction tables to be stored for analysis, archiving, or integration.
  • Retrieve a file from or send a file to a known location using either the File Transfer Protocol (FTP) or the Secure File Transfer Protocol (SFTP). This connector is referred to as an FTP connector. You can also use an FTP connector to retrieve data from a CSV file.
  • Send a file to a known location using a REST protocol.
  • List all the REST services that can be performed on Server Manager using the Open API connector.
  • Invoke REST services from your local AIS server. The session that is already established to execute the orchestration is reused for the current AIS REST call.
Links
Open API Connector How To and FAQ Documents
  • E1: ORCH: Database Connector Sample With Oracle DB and TR 9.2.5.4 and Above - Groovy And Jython [Updated: 02/02/2024]
  • E1: ORCH: How to Assign (Parse) Nested JSON Output (Array Output) Values into Variables in the Connector Output [Updated: 05/01/2023]
  • E1: ORCH: How to use "AND/OR" Filter For Multiple Fields Using "/v2/dataservice/table/{tableName}" API From the Connector [Updated: 08/30/2022]
  • E1: ORCH: How to Pass Output Values from a Service Request (Form, Data, Report, etc) to Connector (External Rest) Body as an Input Variable [Updated: 03/11/2022]
  • E1: ORCH: AIS: How To Call a 3rd Party Web Service (WSDL) From Orchestration [Updated: 08/24/2021]
Orchestration Connector How To and FAQ Documents
  • E1: ORCH: Database Connector Sample With Oracle DB and TR 9.2.5.4 and Above - Groovy And Jython [Updated: 02/02/2024]
  • E1: ORCH: How to Assign (Parse) Nested JSON Output (Array Output) Values into Variables in the Connector Output [Updated: 05/01/2023]
  • E1: ORCH: How to use "AND/OR" Filter For Multiple Fields Using "/v2/dataservice/table/{tableName}" API From the Connector [Updated: 08/30/2022]
  • E1: ORCH: How to Pass Output Values from a Service Request (Form, Data, Report, etc) to Connector (External Rest) Body as an Input Variable [Updated: 03/11/2022]
  • E1: ORCH: AIS: How To Call a 3rd Party Web Service (WSDL) From Orchestration [Updated: 08/24/2021]
Database Connector How To and FAQ Documents
  • E1: ORCH: Database Connector Sample With Oracle DB and TR 9.2.5.4 and Above - Groovy And Jython [Updated: 02/02/2024]
  • E1: ORCH: How to Configure Database Connection Outputs to be used as Service Request Inputs [Updated: 08/07/2023]
  • E1: ORCH: How to Create a Connector for Selecting Data From a Table Using a Variable with the EnterpriseOne Database (Read-only) DAD Connection [Updated: 08/03/2023]
  • E1: ORCH: How to Assign (Parse) Nested JSON Output (Array Output) Values into Variables in the Connector Output [Updated: 05/01/2023]
  • E1: ORCH: Orchestrator and Database Connection / Connector [Updated: 05/01/2023]
  • E1: ORCH: Is it Possible to Create Dynamic Runtime Queries on E1 Tables Using Orchestrator REST API ? [Updated: 04/10/2023]
  • E1: ORCH: How To Configure The DAD (Data Access Driver) In Orchestrator/Connector (EnterpriseOne Database (Read-only) ) [Updated: 04/10/2023]
  • E1: ORCH: How to use "AND/OR" Filter For Multiple Fields Using "/v2/dataservice/table/{tableName}" API From the Connector [Updated: 08/30/2022]
  • E1: ORCH: How To Use the Database Connector To Point To the Correct DB Owner Based on The Login Environment Without Creating Multiple Groovy Script For Multiple Environments? [Updated: 06/14/2022]
  • E1: ORCH: How to Pass Output Values from a Service Request (Form, Data, Report, etc) to Connector (External Rest) Body as an Input Variable [Updated: 03/11/2022]
  • E1: ORCH: How To Call SQL Oracle Stored Procedure From Groovy Using Orchestrator [Updated: 03/09/2022]
  • E1: ORCH: How to Convert Date Format From yyyyMMdd to MM/dd/yyyy [Updated: 03/09/2022]
  • E1: ORCH: How To Output the SUM of Column Values Using Database Connector and Data Service Request (Aggregation) [Updated: 02/21/2022]
  • E1: ORCH: AIS: How To Call a 3rd Party Web Service (WSDL) From Orchestration [Updated: 08/24/2021]
  • E1: ORCH: How to Update a JDE Table with Orchestration ? [Updated: 03/02/2020]
REST Connector How To and FAQ Documents
  • E1: ORCH: How To Configure a Connector (REST) To Upload A File Using Data (Binary) Instead Of Using "multipart/form-data" [Updated: 05/02/2024]
  • E1: ORCH: Database Connector Sample With Oracle DB and TR 9.2.5.4 and Above - Groovy And Jython [Updated: 02/02/2024]
  • E1: ORCH Passing JSON Output to an External REST API via Connector Request - What is the Size Limit? - e.g. 200+ Grid Line Records With Multiple Input Parameter Fails. [Updated: 01/03/2024]
  • E1: ORCH: How to Call an External REST API from an Orchestration [Updated: 06/27/2023]
  • E1: ORCH: Is There Any Redirect URI Which Can Be Defined in External Rest Service for E1. [Updated: 05/25/2023]
  • E1: AIS: ORCH: What is the Significance of the MaxExternalResponseSize Parameter in the Rest.ini? [Updated: 05/16/2023]
  • E1: ORCH: How to Assign (Parse) Nested JSON Output (Array Output) Values into Variables in the Connector Output [Updated: 05/01/2023]
  • E1: ORCH How to Pass Array Payload In An Orchestration [Updated: 12/02/2022]
  • E1: ORCH: How to Add Parameters to Orchestrator Connector [Updated: 11/16/2022]
  • E1: ORCH: How to use "AND/OR" Filter For Multiple Fields Using "/v2/dataservice/table/{tableName}" API From the Connector [Updated: 08/30/2022]
  • E1: ORCH: How To Upload a File as an Attachment Which was Retrieved From a Previous Orchestrator Step (Release 22, 9.2.6.2)? [Updated: 03/21/2022]
  • E1: ORCH: How to Pass Output Values from a Service Request (Form, Data, Report, etc) to Connector (External Rest) Body as an Input Variable [Updated: 03/11/2022]
  • E1: ORCH: How to Create a Connector and then Test using Service Request and Orchestration? [Updated: 02/28/2022]
  • E1: ORCH: How to Send a Report (PDF) to a 3rd Party REST Service - Demonstrate This Using ExternalRest Connector with moAdd (/jderest/v2/file/upload) to Attach the Report as an Media Object [Updated: 02/04/2022]
  • E1: ORCH: AIS: How To Call a 3rd Party Web Service (WSDL) From Orchestration [Updated: 08/24/2021]
  • E1: ORCH: Using Connection for External REST - Post with JSON body [Updated: 01/02/2019]
FTP Connector How To and FAQ Documents
  • E1: ORCH: Database Connector Sample With Oracle DB and TR 9.2.5.4 and Above - Groovy And Jython [Updated: 02/02/2024]
  • E1: ORCH: How To Use Orchestrator To Import Data (Parse) From a JSON File Using FTP - Example/Sample Using JRuby And Jython (Tools Release 9.2.6.0 and Higher) [Updated: 02/02/2024]
  • E1: ORCH: How to Assign (Parse) Nested JSON Output (Array Output) Values into Variables in the Connector Output [Updated: 05/01/2023]
  • E1: ORCH: How To Configure The FTP Connection for SFTP (SSH) Protocol [Updated: 01/18/2023]
  • E1: ORCH How To Use Orchestrator To Import Data From a CSV File - Example/Sample [Updated: 11/15/2022]
  • E1: ORCH: How to use "AND/OR" Filter For Multiple Fields Using "/v2/dataservice/table/{tableName}" API From the Connector [Updated: 08/30/2022]
  • E1: ORCH: How to Pass Output Values from a Service Request (Form, Data, Report, etc) to Connector (External Rest) Body as an Input Variable [Updated: 03/11/2022]
  • E1: ORCH: AIS: How To Call a 3rd Party Web Service (WSDL) From Orchestration [Updated: 08/24/2021]
Softcoding Connector How To and FAQ Documents
  • E1: ORCH: Database Connector Sample With Oracle DB and TR 9.2.5.4 and Above - Groovy And Jython [Updated: 02/02/2024]
  • E1: ORCH: How to Assign (Parse) Nested JSON Output (Array Output) Values into Variables in the Connector Output [Updated: 05/01/2023]
  • E1: ORCH: How to use "AND/OR" Filter For Multiple Fields Using "/v2/dataservice/table/{tableName}" API From the Connector [Updated: 08/30/2022]
  • E1: ORCH: How to Pass Output Values from a Service Request (Form, Data, Report, etc) to Connector (External Rest) Body as an Input Variable [Updated: 03/11/2022]
  • E1: ORCH: AIS: How To Call a 3rd Party Web Service (WSDL) From Orchestration [Updated: 08/24/2021]

Orchestrator Logic Extensions

Orchestrator Logic Extensions How To and FAQ Documents

Orchestrator Custom Requests

Starting with with Tools Release 9.2.1.4 and Orchestrator 5.1.x, you can create a service request that uses Groovy or Java scripting to execute a custom process or to route data into another database.

Starting with Tools 9.2.4.3, you can call a business function directly from an orchestration.

Links
Custom Service Requests How To and FAQ Documents

Orchestrator Messages Request

Messages Request How To and FAQ Documents

Orchestrator Rules

Orchestrator Rules How To and FAQ Documents
  • E1: ORCH: Rule What Is The Separator For Using multiple Values for "in list" Operator? [Updated: 03/14/2022]
  • E1: ORCH: How to Run Orchestration using XML Input [Updated: 03/08/2022]
  • E1: ORCH: Passing The Exception Message to an Orchestration or Notification on Error [Updated: 02/10/2022]
  • E1: ORCH: How to Test Orchestration Input is Empty / Not populated in Rule [Updated: 09/05/2020]

Orchestrator Cross References

Cross References How To and FAQ Documents

Orchestrator Schedules

Schedules: Creating a Schedule Create a schedule to define how often the Orchestrator should execute an orchestration. You can define a schedule using minutes, hours, days, or a Cron string. Cron is a time-based job scheduler that can be used to schedule jobs to run periodically at fixed times, dates, or intervals (for example, every Tuesday and Friday at 9:00 a.m.).

Adding a Schedule to an Orchestration Adding a schedule to an orchestration does not invoke the orchestration as scheduled. Starting the scheduler is a separate step. After you add a schedule, ask an administrator to start and administer the schedule using the Scheduler page

Links
Scheduler How To and FAQ Documents

Orchestrator Monitor

The EnterpriseOne Orchestrator Monitor (P980060X) is an EnterpriseOne application that enables users to monitor the health and performance of Orchestrator components. It also records any exceptions so that users can take corrective actions to resolve any issues.

The following user defined objects (UDOs) can be monitored with Orchestrator Monitor:

  • Orchestrations
  • Notifications
  • Schedules (Only exception information. It does not provide health details)
Links
Monitor How To and FAQ Documents

Orchestrator Connections

  • E1: ORCH: Orchestrator Connections Reference Center (Doc ID 2846191.2)
Connections How To and FAQ Documents
  • E1: ORCH: Which Account is Used When an Orchestration is Running and Accessing External Network Folders. [Updated: 04/11/2024]
  • E1: ORCH: How to Decrypt a REST Response Payload Returned From a Third Party [Updated: 10/18/2023]
  • E1: ORCH: How to Create a Connector for Selecting Data From a Table Using a Variable with the EnterpriseOne Database (Read-only) DAD Connection [Updated: 08/03/2023]
  • E1: ORCH: How To Delete Orchestration Connections From Orchestrator Studio User Interface [Updated: 05/23/2023]

Orchestrator Import/Export

Orchestrator B98ORCH

  • E1: ORCH: Orchestrator B98ORCH Reference Center (Doc ID 2724996.2)
Orchestrator B98ORCH How To and FAQ Documents
  • E1: ORCH: Launching orchestrations from EnterpriseOne Events using B98ORCH [Updated: 06/18/2024]
  • E1: ORCH: How to Run B98ORCH Asynchronously? [Updated: 11/22/2022]
  • E1: ORCH: Is it Possible to Populate B98ORCH Response Into a Form Grid? [Updated: 05/19/2021]
  • E1: ORCH: B98ORCH Calling Connectors With JSON Body [Updated: 01/02/2019]

Orchestrator OMW Promotion

OMW Promotion How To and FAQ Documents
  • E1: ORCH: How "Share/Approve" (Checkin/Checkout) Works for Orchestration UDO Components - P98220U and P98220W [Updated: 03/08/2022]
  • E1: ORCH: How Does Promotion (Promote) Work With Connector With Connections (FTP, REST, DB, etc)? [Updated: 02/10/2022]
  • E1:ORCH Questions on Development and Promoting Objects in Orchestrator Studio [Updated: 06/18/2020]

Orchestrator Form Extension

Orchestrator Form Extension How To and FAQ Documents

Orchestrator Process Recorder

Creating a Form Request with the JD Edwards EnterpriseOne Orchestrator Process Recorder (Release 9.2.2.4)

The JD Edwards EnterpriseOne Orchestrator Process Recorder enables you to record a series of actions in EnterpriseOne and save those actions as a new form request. This simplified method to create a form request is an alternative to manually creating a form request in the Orchestrator Studio.

> Tutorial

> Tutorial 2

After launching and starting the Process Recorder in EnterpriseOne, you access an application and perform each of the steps to complete the business process or transaction that you want the form request to perform.

The Process Recorder automatically adds inputs to the form request for each field in which you enter data during the recording. The input is the name of the field, and the data you enter becomes the default value. For example, if you click a field called Customer Number and enter 1001, the Process Recorder records an input called Customer Number with a default value of 1001. You can delete, change, or replace the value with a variable by editing the form request in Orchestrator Studio.

When finished, on the last form, you can select any of the controls or grid columns on the form that contain values that you want the form request to return. Starting with EnterpriseOne Tools 9.2.3, you can select return values from any form while recording the form request.

After you save the form request in the Process Recorder, you can open the form request in the Orchestrator Studio, modify it as necessary, and add it to an orchestration.

If you have an open Orchestrator Studio session, you can click the Refresh Cache button on the Orchestrator Client page to access the form requests. (Release 9.2.3.4)

Links
Orchestrator Process Recorder (Record a Process) How To and FAQ Documents

Orchestrator Security

Orchestration Security Considerations Before the EnterpriseOne Orchestrator can process an orchestration, authentication of the JD Edwards EnterpriseOne user ID and password must take place. It is the responsibility of the originator of the service request to tell the orchestration about the user. The user's credentials must be supplied in a basic authorization header or in the JSON body of the request. The user must also have authorized access to the EnterpriseOne application in which the resulting transaction takes place. The following code is an example of credentials in the JSON body of the request: { "username":"JDE", "password":"JDE", "environment":"JDV900", "role":"*ALL" } The AIS service used with orchestrations is stateless; each call passes credentials to establish a separate EnterpriseOne session. After the transaction is complete, the session closes. Orchestrations Guide -> Security:

Locate "Orchestration Security Considerations" section in the Orchestrations guide.

Links
Orchestrator Security How To and FAQ Documents
  • E1: ORCH: Which Account is Used When an Orchestration is Running and Accessing External Network Folders. [Updated: 04/11/2024]
  • E1: ORCH AIS How to Configure SSL/https for Communication Between AIS (includes Orch Studio 9.2.4.x) and HTML - Includes Self-Signed [Updated: 08/10/2023]
  • E1: ORCH: How To Control the "New" Button or Access Control Based on a User ID or E1 Role For Workflow In Orchestrator Studio? [Updated: 05/30/2023]
  • E1: ORCH: How to Setup a "_GLOBALNODE" in E1 to Work With JWT trust Using Orchestration/AIS [Updated: 11/17/2022]
  • E1: ORCH: How to Delete Shared UDO used with Orchestrator [Updated: 06/08/2022]