E1: 03B: Unique Key ID Field Blank Is Found in Customer Ledger Summary Work Table (F03B11SW) table (Doc ID 2834735.1)

Last updated on SEPTEMBER 07, 2023

Applies to:

Symptoms

A record is found with Unique Key ID blank in Customer Ledger Summary Work Table (F03B11SW) table.
According to Doc ID 2011430.1, Unique Key ID for objects exists in Unique Key File - Next Available Unique Key (F00022) table. Application P00022 (Next Unique Key Number) is used to enter data into F00022 table. There should be a synchronization between F03B11SW table and the next available number in P00022/F00022. There should be no blanks or null values in F03B11SW for Unique Key ID field as this may lead to unpredictable results, such as unable to add a new record, unable to change or delete an existing record.

Steps to replicate:
1. Start Databrowser;
2. Open F03B11SW table;
3. Search in the table for Unique Key ID blanks or nulls

Cause

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