My Oracle Support Banner

E1: 04: How to Identify Orphaned or Missing Records Found in the Payment Group Worktables (F04571, F04572, F04573) (Doc ID 2818934.1)

Last updated on NOVEMBER 15, 2022

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 (alias HDC).
Whenever there is a Payment Group Number for which there is no information in one of the three tables, these are corrupt, orphan records that could cause problems when attempting to Write or Update Payment Groups.

How to identify and remove these orphaned records 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.