E1: ORCH: How to Iterate Over Multiple Records From a CSV File - Fetch All The Records From a CSV File and Validate if the Same Info. Exists In F0117. If It Does Not Exist, Then Insert The Record. (Doc ID 2872426.1)

Last updated on NOVEMBER 26, 2024

Applies to:

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

How to create orchestration that follow the below steps.

1. Retrieve a csv file via FTP. The csv file contains the list of zip, city, state, county info.

e.g.

2. Check if records exist in F0711.

3. If not, create a record using Form Service Request for P0117.

	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

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