E1: 04: Validate That The Payment ID Field In The Accounts Payable Matching Document Detail table (F0414) Is Populated With A Valid Value For All Records To Prevent Errors When Adding, Changing Or Deleting A Record (Doc ID 2835974.1)

Last updated on SEPTEMBER 07, 2023

Applies to:

Symptoms

 A blank Payment ID has been detected in the Accounts Payable Matching Document Detail table (F0414).
There should be no record where the Payment ID (PYID) field is blank or zero as this may lead to unpredictable results; such as being unable to add a new record, unable to make changes to an existing record, etc.
Therefore the users will have to ensure that the Payment ID field is not blank or zero in F0414 table.

Steps

1. Start Databrowser and open F0414 table
2. Sort by field Payment ID (PYID) and see if any blank or zero

Changes

Cause

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