My Oracle Support Banner

E1: 01: FAQ - Frequently Asked Questions on Address Book Set Up (P0000, P0007, P0004A, P0002, P0117, P0100041, P0100042, P0100043, P95922, P01BDWRD, R01BDWRD) (Doc ID 1510896.1)

Last updated on MARCH 12, 2021

Applies to:

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


This document provides answers to frequently asked questions about initial Address Book set up.

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
Questions and Answers
 Country Constant Questions
 Question 1: Why is the country name not showing in the vendor address portion of accounts payable check?
 Question 2: Why does the Formatted Address with Who's Who (B0100067) incorrectly formatting the Mailing Name to print after Address Line number 1?
 Question 3: Which programs are impacted when changing the address format for a country in the Country Constants (P0070)?
 Address Book User Defined Code (UDC) Questions
 Question 1: What is the purpose of the special handling code in UDC 00/CN?
 Question 2: How can UDC 00/S be used for states from different countries, if these states have the same abbreviation, e.g. AL is Alabama (US) but is also Alagoas (Brazil)?
 Question 3: When an Address Book record contains a space in the Alpha Name, why is this space value included in the Description Compressed’ field (ABDC) in the Address Book Master (F0101)?
 Question 4: Error: Why does the system trigger error ‘Not found in User Defined Code xx/xx’ for various Address Book UDC values although there is no value in the specified field?
 Address Book Category Code Questions
 Question 1: How can Category Codes in the Address Book be made mandatory for the user to input a value?
 Question 2: Can Address Book Master Category Codes (P01012) be updated to the Customer Master Category Codes (P03013) after a customer AB record has been created?
 Question 3: How does a user update the processing options or data selection for Global Category Code Update UBE (R01490) when receiving the error, 'Security Error - User restricted from selection process'?
 Question 4: Is it possible increase the length of the category code fields?
 Next Number Questions
 Question 1: Why are Address Book Next Numbers Skipping Sporadically? Next Numbers by Company is not active and Check Digit functionality is not active.
 Question 2: What happens when the maximum next number is reached in Address Book?
 Audit Log Questions
 Question 1: Is it possible to keep an audit trail log for the Address Book system to track changes?
 Question 2: Does JD Edwards EnterpriseOne provide reports showing Address Book Audit Log information?
 Question 3: When you have A/B interoperability activated in MBF P0100041 so that the system creates records in the F0101Z2 table, should the system be creating entries in the Subsystem Waiting Jobs?
 Question 4: Can user-defined Transaction Types be used for outbound Address Book Audit Log functionality?
 Question 5: When a phone number whose line ID is greater than 2 is changed, the changes are not recorded in interoperability table F0101Z2?
 Question 6: Why does the system trigger error “Records not selected. (Verify selection criteria), and Next Numbers not found” when changing Address Book information when Address Book Audit logging has been turned on (Outbound Interoperability) in the Address Book Master Business Function (BSFN) P0100041?
 Question 7:When CREDLIMIT is implemented to send Credit Limit Amount changes through the JDE workflow, why is there no before/after image created in table F03012 when selecting the 'Approval' button through work center?
 Question 8: When a change is made to an address book record in World, the system updates the F0101A table to reflect the changes. Why is this table not being updated in EnterpriseOne?
 Question 9: What are the different types of Transaction Action codes (TNAC) used for Address Book or Customer Master Outbound Interoperability?
 Question 10: Can Outbound Interoperability records be purged?
 Effective Address Date Questions
 Question 1: Why can the address on the mailing tab (P01012) not be changed if the Effective Address Date option was initially selected in the Address Book Constants  (P0000) and then turned off? The change is reflected in the Address By Date table (F0116), but not in the Address Book Revisions application (P01012).
 Question 2: Why does the Update Effective Address UBE (R01840) produces a blank report (only the headers are printed)?
 Question 3: Why is it necessary to run the Update Effective Address UBE (R01840) with data selection "Where effective date existence (F0116) is not equal to 1"?
 Question 4: Why does the system trigger error ‘Fetch from Table F0116 Failed’ (error number 078I) when trying to update an existing Address Book record in the Address Book Master application (P01012)?
 Question 5: Does the Effective Date functionality work for name changes in the address book as well as address changes?
 Question 6: Does the Update Effective Address UBE (R01840) automatically call R730101 to update invalid geocodes when vertex is being used?
 Question 7: Why is the Update Effective Address UBE R01840 updating F42140 end date and expiring customer master commission records?
 Question 8: Under what circumstances does the Update Effective Address (R01840) update the Tax Rate Area in the Customer or Supplier Master tables?
 Address Book Word Search, Word Search Build (R01BDWRD) Questions
 Question 1: What is User Defined Code (UDC) H95|SC used for?
 Question 2: Which Business Functions (BSFNs)  use UDC H95/SC?
 Question 3: What  settings are required to get expected results in the stripping of a string?
 Question 4: During runtime, what kind of BSFNs make use of this settings?
 Question 5: How is BSFN "B0100009 - CompressCharacterString strips special characters" defined in the Description001 column in UDC H95/SC?
 Question 6: Can its definition change? Will there be any impact?
 Question 7: Is there any batch application which can update F0101.ABDC and F0111.WWDC columns?
 Question 8: Are there any other considerations when setting up Word Search?
 Question 9: When searching by the first letter of the Alpha Name, why are not all  records displayed?
 Question 10: Which fields are included when running the Address Book Word Search Build (R01BDWRD)? 
 Address Book Word Search Common Errors
 Question 1: Searching for Address Book records using the Alpha Name field at the top of the Address Book Master form (P01012) provides different results than using the application’s QBE (Query By Example) line.
 For example: Enter Denver C* in the Alpha Name field, no results are displayed. Enter the same search criteria in the Alpha Name field in the QBE line, the system retrieves: Denver County, Denver Club, Denver Complex, etc.
 External Mail Questions
 Question 1: The system has been set up to send messages to an external e-mail address instead of the EnterpriseOne workcenter. In addition to workflow message and submitted job messages, will the system send any other type of messages?
 Question 2: Where can I store external e-mail addresses for contacts, such as suppliers and customers, within Address Book?

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