My Oracle Support Banner

E1: 01: FAQ - Frequently Asked Questions on Address Book Batch Upload (P0101Z1, R01010Z, P0111Z1, R011110Z, R01010Z1P) (Doc ID 759369.1)

Last updated on SEPTEMBER 07, 2018

Applies to:

JD Edwards EnterpriseOne Address Book - Version XE and later
Information in this document applies to any platform.

Purpose

This document provides answers to frequently asked questions regarding Oracle JD Edwards EnterpriseOne Address Book Batch Upload process.

Questions and Answers

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
Questions and Answers
 Address Book Batch Upload Questions
 Question 1: Is it possible to delete records from the Supplier Master table (F0401) using the Address Book Batch Upload UBE (R01010Z) and if so, which tables will be affected?
 Question 2: What happens when Action Code C (Change) for the transaction type is used?
 Question 3: Which table does the related address -parent number updates?
 Question 4: What is the purpose of the F0101Z tables?
 Question 5: Are Address Book Interoperability records (F0101Z2) accessed by the Address Book Batch Revisions program (P0101Z1)?
 Question 6: Is it possible to upload phone numbers?
 Question 7: Is it possible to upload contact information?
 Question 8: Why are there no records in the Contact Information (F01111) table after contact information was uploaded?
 Question 9: Which fields are required for Address Book Batch Processing?
 Question 10: Is there a maximum number of "Z table" records that can be processed in the same batch for the various batch upload processes in the the Address Book, Accounts Receivable, and Accounts Payable modules?  For example, is there an absolute limit on how many Address Book records can be processed successfully by the Address Book Batch Upload UBE (R01010Z)?
 R01010Z Common Error Questions
 Question 1: Why is error 'Address Book Record Invalid'  issued when processing transactions?
 Question 2: Why is error 'duplicate not allowed' trugger when running R01010Z. The message in the Work Center is as following: "Subject: Error: Duplicate not allowed; CAUSE: You have entered a value in this field which is a duplicate of a value already entered on the screen. This value must be unique."
 Question 3: The R01010Z UBE shows 113 errors occured and the next number skips 113 for the address book number. It is wasting next numbers. Why does it do this each time it is run? 
 R011110Z Common Error Questions
 Question 1: Why is the Who's Who Batch Upload (R011110Z) failing to pick up the records in the Who's Who Worktable (F0111Z1) when all of the required fields are populated?
References

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