E1: 01: How To Upload Address Book and Who's Who Batch Records (P0101Z1, R01010Z, P0111Z1, R011110Z, R01010Z1P)
(Doc ID 1517639.1)
Last updated on MARCH 23, 2021
JD Edwards EnterpriseOne Address Book - Version 9.2 and later Information in this document applies to any platform.
Overview of Address Book Batch Processing
Batch processing enables you to convert Address Book and Who's Who information from an external source and transfer it to the JD Edwards EnterpriseOne Address Book system. It is also possible to convert customer master and supplier master data as separate processes - see <Document 625788.1> E1: 03B: Customer Master Batch Processing (R03010Z) and <Document 625789.1> E1: 01: How To Upload Supplier Master Records (R04010Z) for further information.
To convert address information from an external source, you must create a custom program that transfers the data from your external system to specific fields in the corresponding batch input tables. The custom program that you create must provide proper data to fields in these batch input tables:
Address Book - Interoperability (F0101Z2)
Batch Who’s Who Information (F0111Z1)
Batch - Related Person (F01112Z1)
Batch - Electronic Address (F01151Z1)
Batch - Alternative Address (F01161Z1)
Certain fields are required to upload address book records. Additional fields that include more detail are optional. Other fields are ignored or reserved for users. See field mapping tables below.
After you transfer information from an external source to the batch input tables, you can review, add, revise, and delete address book, and who’s who information. Then you run a batch upload program to process the information and transfer it to the appropriate JD Edwards EnterpriseOne master tables. The batch upload programs:
Create address records in the Address Book Master table (F0101).
Create address records in the Who’s who table (F0111) if applicable.
Create records in the Related Person table (F01112).
Create records in the Electronic Address table (F01151).
Create records in the Alternate Address table (F01161).
Assign address book numbers, if applicable.
Supply information for blank fields.
Produce a report.
The batch upload programs generate reports that print the records processed, a total of the number of records processed, and the records that were in error. You can change records that were not processed and rerun the batch program. The processed batches remain in the respective batch input tables until you purge the batch.
This document is intended for users setting up and processing batch Address Book records in EnterpriseOne.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!