My Oracle Support Banner

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

Last updated on OCTOBER 27, 2022

Applies to:

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

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

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
Cause
Solution
References

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