My Oracle Support Banner

E1: 03B: Unique Key ID field blank is found in Revenue Recognition Invoice To Account Ledger (F03B116W) table (Doc ID 2827217.1)

Last updated on DECEMBER 09, 2021

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 Revenue Recognition Invoice To Account Ledger (F03B116W) 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 F03B116W table and the next available number in P00022/F00022. There should be no blank values in F03B116W 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 and open F03B116W
2. Filter the table by Unique Key ID

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.