E1: 04: Integrity to Reconcile AP tables F0413 to F0414 by Payment ID (PYID) (Doc ID 2032462.1)

Last updated on MAY 31, 2016

Applies to:

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

Symptoms

Issue: Presently there isn't an integrity report to compare the Accounts Payable - Matching Document table (F0413) to the Accounts Payable Matching Document Detail table (F0414) by Payment ID (PYID). If the processing of a payment is successful, the respective Payment ID will not show up on the report. However, if there is an issue with posting a payment or a database failure, records may effect in one or both tables. There is no easy way to determine if records within the respective Accounts Payable Matching Document are damaged or records missing.

Desired Outcome: Provide a report listing discrepancies by Payment ID (PYID) so that the user can quickly correct the record involved so that the payment can be supported by the detail for audit purposes.



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms