R12: AP/XLA: Code Fix (RCA) For GDF 20086994: Accounted Amounts are Out of Sync With Invoice Distribution Amounts (Doc ID 2943662.1)

Last updated on APRIL 20, 2023

Applies to:

Symptoms

The amounts on the invoice distributions are not in sync with the related amount in the subledger accounting tables.
This can cause incorrect payment accounting, or leave the transaction on the trial balance even when fully paid or cancelled.

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. Update the amount on one of the accounted distributions, from the form if it will allow it, or via custom SQL
7. If the invoice is affected by this issue, then the amounts in AP_INVOICE_DISTRIBUTIONS_ALL will not match the amounts in XLA_DISTRIBUTION_LINKS.

Cause

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