My Oracle Support Banner

R12:AP: Generic Data Fix (GDF) Patch 20086994 - Accounted Amounts are Out of Sync With Invoice Distribution Amounts (Doc ID 1063263.1)

Last updated on DECEMBER 08, 2023

Applies to:

Oracle Payables - Version 12.0.0 and later
Oracle Subledger Accounting - Version 12.0.0 and later
Information in this document applies to any platform.


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.


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

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