My Oracle Support Banner

E1: 03B: Validate that the unique key field in the Customer Master table (F03012) is populated with a valid value for all records to prevent errors when adding, changing or deleting a record (Doc ID 2830055.1)

Last updated on DECEMBER 23, 2021

Applies to:

JD Edwards EnterpriseOne Accounts Receivable - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

A blank unique key has been detected in the Customer Master table (F03012).
According to Doc ID 1478003.1, Address Book numbers (AN8) will default from Next Numbers (P0002)/F0002 (Next Numbers- Automatic) as the record is created.
There should be no record where the Address Book Number (AN8) is blank or zero as this may lead to Address Book applications providing unpredictable results; such as being unable to add a new record, unable to make changes to an existing record, unable to retrieve an address book master, etc.
Therefore the users will have to ensure that the Address Book field is not blank or zero in F03012 or F0002 tables

Steps to replicate:
1. Start Databrowser and open F03012
2. Filter the table by Address Number (AN8) and see if any blank or zero

Cause

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
Symptoms
Cause
Solution
References

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