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 SEPTEMBER 07, 2023

Applies to:

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

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