My Oracle Support Banner

E1: ORCH How To Use Orchestrator To Import Data From a CSV File - Example/Sample (Doc ID 2564800.1)

Last updated on JANUARY 12, 2024

Applies to:

JD Edwards EnterpriseOne Orchestrator - Version 9.2 and later
Information in this document applies to any platform.

Goal


How to import data into E1 tables (for eg. Sales Order) using a CSV file via FTP?

In-case you are looking for information on how to import data (Parse) from a Json file using FTP, review the document - E1: ORCH: How To Use Orchestrator To Import Data (Parse) From a JSON File Using FTP - Example/Sample Using JRuby (Tools Release 9.2.6.0 and Higher) (<Doc ID 2905923.1>)

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution
 Prerequisites:  
 Create an Orchestration to Add Sales Order in E1. 
 Create a "Enter Sales Order" Orchestration 
 Access the Orchestrator Studio. 
 Test the "Enter Sales Order Orchestration
 Create an Orchestration that reads data from a CSV file to create Sales Orders in E1. 
 Access Orchestrator Studio
  Add the Connector to your SO Orchestration
  Test it using Orchestrator Client
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.