My Oracle Support Banner

E1: 04: How to Identify Corrupted Records Found in the Payment Group Worktables (F04571, F04572, F04573) (Doc ID 2844006.1)

Last updated on NOVEMBER 18, 2024

Applies to:

JD Edwards EnterpriseOne Accounts Payable - Version XE and later
Information in this document applies to any platform.

Goal

Whenever a Payment Group is created, the AP Automatic Payment worktables (F04571, F04572 or F04573) are populated with information for that Payment Group.

All the records for one specific Payment Group can be identified in the three tables querying by Payment Group Number (HDC).

If the Payment Group Number is blank or zero in any of the above tables, that Payment Group is corrupted and could cause unexpected results when attempting to Write or Update the Payment Group.

The Payment Group is also corrupted when some important information like G/L Bank Account (GLBA), Address Number (AN8), Payee Address Number (PYE), Company (CO), Document Number (DOC), Document Type (DCT), Invoice Date (DIVJ) is not populated in the corresponding fields of the AP Automatic Payment worktables (F04571, F04572 or F04573).

How to identify and remove corrupted records found in the Payment Group Worktables (F04571, F04572, F04573)?

Solution

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

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