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

Last updated on JULY 01, 2024

Applies to:

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:

• 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.

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

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