Orchestrator

WHAT IS ORCHESTRATOR?

Orchestrator, a JD Edwards EnterpriseOne tool already available at your fingertips, allows you to build microservices. It’s designed to be used by analysts, developers, and super users who have a good understanding of the EnterpriseOne application.

It can be used for:

  • IoT – connect to external devices and generated data
  • User Interface – display filtered and gathered data
  • Process Simplification – perform pre-recorded tasks
  • Extend Integrations – invoked from external system by calling the endpoint
  • Autonomous ERP – transform how you use the JDE system by automating processes and generating reports, notifications, and kicking off additional services

When approaching orchestrations, it’s important to remember to keep it simple; break down orchestrations into small pieces.

Think about the customizations you have in place and what you could automate. Use your imagination and think about how you can use orchestrations in your industry as well as in your specific role. Use multiple orchestrations where you can and leverage EnterpriseOne.

It’s also important to test the limits of the data set and reach the top capabilities of the integration to find issues before fully diving in. It also helps to have trusted and experienced resources on hand when you need it.

BASIC FLOW & COMPONENTS

Request Orchestrator White Paper
EnterpriseOne Orchestration Processing image from: https://docs.oracle.com/cd/E53430_01/EOTOT/understand_iot.htm#EOTOT107

Other Components:

  • Connection “Soft Coding” Setup - host, credentials, port, drivers
  • Notifications - for workcenter notifications, users “subscribe” to the notifications, similar to a personalized RSS
  • Orchestrator Monitor - monitor performance, errors of orchestrations
  • Orchestrator Client - testing client
  • Orchestrator Scheduler

TYPES OF SERVICE REQUESTS

Custom Service Requests
Used to develop custom functionality with GROOVY

Form Service Requests
Used to interact with JDE application forms
Automate user actions with the Process Recorder

Report Service Requests
Used to execute JDE UBE (Universal Batch Engine) for
data extraction, transformation, publication, and distribution

Data Service Requests
Used to query and aggregate data from JDE
Basic queries for tables or views

Watchlist Service Requests
Used to query, check, and evaluate
JDE Watchlists for action

Message Service Requests
Used to send messages to JDE users
Email message with additional attachments

Connector Service Requests
Used to connect to external systems, databases, or orchestrations
REST, DB, FTP, etc.

EXAMPLE USE CASES

Exceptions Reporting

Inactive IDs

We’d always recommend our customers to run weekly checks to find out if employees with terminated status have their JDE User IDs disabled, to avoid the risk of someone using inactive User IDs to carry out fraud. If you don’t carry out these checks, you may only find out about them as external audit findings.

But carrying out the checks typically takes a lot of manual work, creating a custom report in a reporting tool, joining tables, exporting the results to Excel and defining formulas to perform the data comparisons.

Now you could create an orchestration that checks the values in those two items of data and reports on any exceptions.

Process Compliance Audit

Check Any Lingering Transactions

Before you close out the month, it’s a good idea to check that all relevant transactions are accounted for, with no transactions left unposted, or batches left unposted due to errors in a batch.

You could create an orchestration to run a report just before the month is closed out to identify any batches that have failed, or any items that are unposted, so they can be resolved.

New AB Records From External HR

External System Provides Data To Import

When you transfer information about new employees into your JDE system, you need to create an address book record and a new User IDs in JDE for those people. Currently this may be done by two separate people – one manually inputs the data into JDE address book; the other creates the User IDs.

You can now create an orchestration that will receive the data from the HR system, then create the Address Book entry and the User ID, and notify you when the orchestration is complete.

General Integration

Help Desk, HR, Manufacturing, etc. can call Orchestrator mid-process

The best release to be on to take advantage of the latest Orchestrator functions is 9.2.4.4. Click here if you’re looking for upgrade help.