My Oracle Support Banner

E1: 01: Validate the Unique Key Field in the Supplemental Data Table (F00092) is Populated with a Valid Value for All Records to Prevent Errors (Doc ID 2830091.1)

Last updated on JANUARY 14, 2022

Applies to:

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

Symptoms

A blank or zero unique key has been detected in the Supplemental Data table (F00092).
The next number for the Unique Key ID (UKID) in the Supplemental Data (F00092) is stored in the Next Unique Number (P00022) program.
Supplemental Data table (F00092) should be populated with a valid value for all records to prevent errors when adding, changing or deleting a record.

Steps to identify the records:

1. Start Databrowser and open F00092
2. Do Query with no specific criteria and sort the records by UKID ascending to identify the records.

Changes

 

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
Changes
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.