E1: 04: Enhancement to Use Payment ID (PYID) to Join F0413, F0414 and F0911 Tables Together for R04712 - A/P Payments to G/L Integrity with Adjust (Doc ID 3006013.1)

Last updated on FEBRUARY 22, 2024

Applies to:

Symptoms

The A/P Payment to G/L Integrity report R04712 generates 'bogus' exceptions for duplicate manual payment numbers in the same batch.

The problem is on the R04712 - A/P Payments to G/L Integrity with Adjust integrity report. We create separate/detailed F0911 records for each payment. When R04712 accumulates the distribution amount (F0911) and Automatic Offset Amount (F0911), it is using the payment number with the batch number. This is wrong. This is causing the program to accumulate the amounts for all the duplicate payment numbers in the batch.

For example, for batch 3577000, we have three payments for 700.00, 0.00, and 113.30. All three payments have the same payment number of 111000. On the report, for each payment, the distribution amount and automatic offset show as 813.30 (which is the sum of the three payments) instead of 700.00, 0.00, and 113.30 respectively. The report says that the amounts do not match the payment amount and prints out an exception.

R04712 should be using the Payment Id (PYID) and Batch Number from the F0413 to look up the two amount types.

Cause

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