E1: 04: Validate That The Unique Key Field In The Supplier Ledger Summary Work table (F0411SW) Is Populated With A Valid Value For All Records To Prevent Errors When Adding, Changing Or Deleting A Record (Doc ID 2835939.1)

Last updated on SEPTEMBER 07, 2023

Applies to:

Symptoms

 A blank unique key has been detected in the Supplier Ledger Summary Work table (F0411SW).
There should be no record where the Unique Key (UKID) field 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 Unique Key field is not blank or zero in F0411SW table.

Steps:

1. Start Databrowser and open F0411SW table
2. Sort by field Unique Key (UKID) 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.