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

Applies to:

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

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