E1: 04: Validate That The Unique Key Field In The Supplier Master Table (F0401) Is Populated With A Valid Value For All Records To Prevent Errors When Adding, Changing Or Deleting A Record (Doc ID 2834435.1)

Last updated on SEPTEMBER 07, 2023

Applies to:

Symptoms

A blank unique key has been detected in the Supplier Master table (F0401).
There should be no record where the Address Book Number (AN8) is blank or zero as this may lead to unpredictable results; such as being unable to add a new record, unable to make changes to an existing record, etc.
Therefore the users will have to ensure that the Address Book Number field is not blank or zero in F0401 table.

Steps to replicate:
1. Start Databrowser and open F0401 table
2. Sort by field Address Book 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.