My Oracle Support Banner

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 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 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

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.