My Oracle Support Banner

WS: FIN: Using Batch Import to Upload Data to Batch Files (Z and Z1) (Doc ID 1368622.1)

Last updated on FEBRUARY 28, 2018

Applies to:

JD Edwards World Fixed Assets - Version A9.1 and later
JD Edwards World Accounts Receivable - Version A9.1 and later
JD Edwards World Accounts Payable - Version A9.1 and later
JD Edwards World Address Book - Version A9.1 and later
JD Edwards World General Ledger - Version A9.1 and later
Information in this document applies to any platform.

Purpose

Instead of creating a custom program to upload information to the batch files, you can use the batch import process to create a template in the comma delimited format (.csv) with all the fields available for the batch file. You can then save the template as an Excel spreadsheet and then populate and format the fields necessary to process the data through the system. Prior to importing the data you save the spreadsheet as a comma delimited file (.csv).

The following are examples of batch files. See document ID 1206790.1 for additional Z files:

 

This document provides the detailed steps on how to use batch import, instead of a custom program, to upload records to the batch (Z1) files.

Scope

This document is intended for anyone responsible for mapping and processing batch files. This document is not intended to provide the details of how to populate the files, rather it details the steps for importing the data to the batch files. The concepts in this document can be applied to any valid batch import file (see the user defined table for system code 00, user defined code BI).

If you are on release A9.1, download and apply the software update <JDEWorld:A918619078> to obtain the import functionality. Release A9.2 and beyond has expanded features and additional files for batch import.

Review the reference documents for details on specific batch file processes.

Details

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
Purpose
Scope
Details
 Creating the Template
 Updating the Template (Spreadsheet)
 Uploading the Batch File
 Processing the Batch File
References

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