My Oracle Support Banner

E1: 03B: Unique Key ID field in Customer Ledger Summary Work Table (F03B11SW) is higher than Unique Key ID in Unique Key File - Next Available Unique Key (F00022) (Doc ID 2830103.1)

Last updated on DECEMBER 23, 2021

Applies to:

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

Symptoms

 A record was found in the Customer Ledger Summary Work Table (F03B11SW) with the Unique Key ID higher than the next unique key value in Unique Key File - Next Available Unique Key (F00022). According to Doc ID 2011430.1, Unique Key ID for objects exists in 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. Unique Key ID in the F00022 table should be higher than the highest Unique Key value written in the F03B11SW table in order to prevent errors when adding, changing or deleting a record.

Steps to replicate:
1. Start Databrowser and open F03B11SW
2. Filter the table by Unique Key ID
3. Compare the value above with the Unique Key ID from P00022 for F03B11SW table

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.