My Oracle Support Banner

R12: AP: Unable To Validate an Invoice With ‘Dist Variance’ Hold Name Caused by a Validated Distribution Having Mismatch Amount Between Line and Distribution (Doc ID 2987896.1)

Last updated on DECEMBER 15, 2023

Applies to:

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


The user is not able to validate an invoice.
The invoice has 'Dist Variance' hold name, 'Total of invoice distributions does not equal invoice amount' hold reason and status is "Needs Revalidation".


  1.  Go to Payables responsibility - Entry - Invoices
  2. Click on Find Invoices button
  3. Search for the affected invoice
  4. Click on Holds tab



The issue can be checked with the following SQL query:






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.