Home / Educational Content / JD Edwards / INFOCUS 22: JD Edwards Orchestration – 3rd party integration for multi-level data retrieval and file archival automation

INFOCUS 22: JD Edwards Orchestration - 3rd party integration for multi-level data retrieval and file archival automation

Presented at INFOCUS 22
Session ID:100940

Worried about time-consuming processes to load from 3rd party systems to JDE system? Who doesn’t like to have error free data in their systems? Reduce the processing time from hours to minutes with orchestrator automation. We will present a real-world use case where we use orchestrator to integrate complex data, automate the data entry, and archive source documents in a single automated process flow. Our use case will demonstrate retrieving multi-level bill of material data from an 3rd party engineering system into JD Edwards through a series of Orchestrations. This process reduces the time to validate and load BOM data after engineering changes and brings all the related specs and drawing documents to an archive location for easy access. The Orchestration is being triggered from a program with minimal inputs with the Parent Item Number from JDE. Based on this Item Number the details of BOM by parts, supporting documents and references are retrieved for both the parent item and multilevel child items up to level ‘n’. Our example retrieves bill of material data and reference documents, but the concepts can be applied to any system integration.

Objectives

3rd Party interface and Automation: Integration with 3rd party interface has become a common practice to retrieve data with less effort saving hours of human effort.
Here we were able to showcase the use of Orchestration to import 3rd party data through multiple parsing and iterations in automating the current legacy process.
This automation process has drastically helped the customers in decreasing their hours of manual work into minutes, which has helped in eliminating human errors while group Archival Process:
The automated archival process has enabled the users / vendors who have access the specified folder to discover, indulge and review the set of documents at one placer.
The Automation helps in moving the files periodically based on jobs submitted from the BI Archival folder to the final document repository folder that is being differentiated by Company, Vendor Number, PO Number, and date/time.
Bill of Material Components:
With this automated it was possible to fetch all the BOM details up to ‘n’ levels including all the possible inputs by the 3rd party API’s.

Watch the full-length video

Premium Content: access is limited to Quest Corporate and Professional members.

Membership has its perks. Get unlimited access to the latest Oracle updates, event session replays, strategic content centers and special members-only programming, plus big discounts on conference registration, with a Quest Corporate or Professional membership. Quest is where you learn.

INFOCUS 22: JD Edwards Orchestration - 3rd party integration for multi-level data retrieval and file archival automation