My Oracle Support Banner

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:

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

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

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

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