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

Материал из JD Edwards E1
Перейти к навигации Перейти к поиску
Строка 254: Строка 254:
 
::* [https://support.oracle.com/epmos/faces/DocumentDisplay?id=2733709.1 E1: ORCH: How To Iterate Over a Form Service Request Without Grid Records - Example: P0015A work With Currency Exchange Rate] [Updated: 03/09/2022]
 
::* [https://support.oracle.com/epmos/faces/DocumentDisplay?id=2733709.1 E1: ORCH: How To Iterate Over a Form Service Request Without Grid Records - Example: P0015A work With Currency Exchange Rate] [Updated: 03/09/2022]
 
::* [https://support.oracle.com/epmos/faces/DocumentDisplay?id=2729899.1 E1:ORCH: Orchestrator does not Support Creating Array Variables from Subform Grids Forms] [Updated: 11/18/2020]
 
::* [https://support.oracle.com/epmos/faces/DocumentDisplay?id=2729899.1 E1:ORCH: Orchestrator does not Support Creating Array Variables from Subform Grids Forms] [Updated: 11/18/2020]
 
=== Orchestrator Logic Extensions ===
 
* [https://support.oracle.com/epmos/faces/DocumentDisplay?id=2908653.2 E1: ORCH: Orchestrator Logic Extensions Reference Center] (Doc ID 2908653.2)
 
: Orchestrator Logic Extensions How To and FAQ Documents
 
::* [https://support.oracle.com/epmos/faces/DocumentDisplay?id=2969261.1 E1: ORCH: Logic Extension - How to Fetch Records From a Table And Based On the Result Of the 1st Table, Update Another Table Using Table I/O (Array) 9.2.7.0 and above] [Updated: 02/13/2024]
 
::* [https://support.oracle.com/epmos/faces/DocumentDisplay?id=2962546.1 E1: ORCH: Can a Logic Extension be Called After the Cancel (X) Button has Been Clicked to Display a Warning Message and Prompt Y/N?] [Updated: 07/19/2023]
 
::* [https://support.oracle.com/epmos/faces/DocumentDisplay?id=2922650.1 E1: ORCH: Are Logic Extensions Included In The Decustomizer (R9540DC - Decustomizer Dataload Report)?] [Updated: 01/20/2023]
 
::* [https://support.oracle.com/epmos/faces/DocumentDisplay?id=2901832.1 E1: ORCH: LE: New Feature Release 23 Tools Release 9.2.7.0 Array and Aggregation Support in Logic Extensions] [Updated: 10/20/2022]
 
::* [https://support.oracle.com/epmos/faces/DocumentDisplay?id=2901820.1 E1: ORCH: BSFN: Is There A Wait Function That Can be Used in Logic Extensions (LEX) in Orchestrator Studio] [Updated: 10/10/2022]
 
  
 
=== Orchestrator Messages Request ===  
 
=== Orchestrator Messages Request ===  

Версия 17:17, 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 Rules

  • E1: ORCH: Orchestrator Rules Reference Center (Doc ID 2725385.2)
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 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 Scheduler

  • E1: ORCH: Orchestrator Scheduler Reference Center (Doc ID 2725469.2)
Scheduler How To and FAQ Documents
  • E1: ORCH: Frequently Asked Questions for Orchestrator Scheduler [Updated: 12/13/2023]
  • E1: ORCH: How to Start/Stop a Scheduler Server, Start/Stop a Scheduled Job, List Scheduled Jobs Manually using Postman - Scheduler REST APIs [Updated: 02/24/2022]

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 Request

Form Service Request How To and FAQ Documents

Orchestrator Messages Request

Messages Request How To and FAQ Documents

Orchestrator Form Extension

Orchestrator Form Extension How To and FAQ Documents

Orchestrator Cross References

Cross References How To and FAQ Documents

Orchestrator Import/Export