WS: FIN: Using Batch Import to Upload Data to Batch Files (Z and Z1)
(Doc ID 1368622.1)
Last updated on MAY 22, 2020
Applies to: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
JD Edwards World Technical Foundation - Version A9.1 and later
Information in this document applies to any platform.
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:
- Address Book - Batch File - F0101Z1
Journal Entry Transactions - F0911Z1
Voucher Transactions - F0411Z1
Invoice Transactions - F0311Z1
Address Book Revisions - F01051Z *
Category Codes - F010512Z *
Phone Numbers Header Z File - F01075HZ *
Phone Numbers Detail Z File - F01075DZ *
Bank Account Header Z File - F0030HZ *
Bank Account Detail Z File - F0030DZ *
Bank Account Additional Information Z File - F0030W1Z *
Asset Master Revisions - F1201Z *
*Available in A9.2 and above.
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.
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.
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
|Creating the Template|
|Updating the Template (Spreadsheet)|
|Uploading the Batch File|
|Processing the Batch File|