E1: 03B: Unique Key ID field in Revenue Recognition Invoice To Account Ledger (F03B116W) is higher than Unique Key ID in Unique Key File - Next Available Unique Key (F00022) (Doc ID 2827519.1)

Last updated on SEPTEMBER 07, 2023

Applies to:

Symptoms

A record was found in the F03B116W 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 F03B116W 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 F03B116W table in order to prevent errors when adding, changing or deleting a record.

Steps to replicate:
1. Start Databrowser and open F03B116W
2. Filter the table by Unique Key ID
3. Compare the value above with the Unique Key ID from P00022 for F03B116W 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.