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

Last updated on SEPTEMBER 07, 2023

Applies to:

Symptoms

A blank unique key has been detected in the Bank Transit Master table (F0030).
There should be no record where the Unique Key (UKID) 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 F0030 table

Steps to replicate:
1. Start Databrowser and open F0030 table
2. Sort by field Unique Key (UKID) and see if any blank or zero

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.