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

Applies to:

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

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