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 SEPTEMBER 07, 2023

Applies to:

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

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