R12: Generic Data Fix (GDF) Patch For Incorrect Foreign Payment Accounting Due To Incorrect Rounding (Doc ID 1316588.1)

Last updated on SEPTEMBER 07, 2023

Applies to:

Symptoms

Foreign currency Payment has incorrect accounting due to incorrect rounding happened to invoice_dist_base_amount in ap_payment_hist_dists table.
Due to which fully paid invoices are listed by the Payables Trial Balance report with small amounts as remaining amount.

Steps to reproduce:

1. Log into Oracle applications using a Payables responsibility.
2. Open the Invoice Workbench
   (N) Invoices > Entry > Invoice
3. Create an invoice by entering data on a new line
   
4. Validate and approve the invoice
   1. Click on the [Actions] button
   2. Check the "Validate" and "Force Approval" checkboxes
   3. Click [OK]
5. Create accounting for the invoice
   1. Click on the [Actions] button
   2. Check the "Create Accounting" and "Final Post" checkboxes
      
   3. Click [OK]
6. Pay the invoice
   
   1. Click on the [Actions] button
   2. Check the "Pay in Full" checkbox
   3. Click [OK]
7. Enter all the needed details and account the respective payment
   
   1. Click on the [Actions] button
   2. Check the "Create Accounting" and "Final Post" checkboxes
   3. Click [OK]
8. Run the Payables Trial Balance report
   View - Requests - Submit a New Request - Single Request - OK
   Run Accounts Payable Trial Balance
   

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.