My Oracle Support Banner

R12: AP/PO: Generic Data Fix (GDF) Patch - Unable to Discard PO Matched Invoice Lines - Mismatch Between AP and PO Values (Doc ID 982072.1)

Last updated on JANUARY 30, 2024

Applies to:

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


Mismatch in values between Payables Invoice Distributions and Purchase Order Distributions

OR, When user tries to discard a PO matched invoice line, the error AP_INV_LINE_QTY_BILLED_NOT_NEG occurs:

Discarding this invoice line is not allowed as quantity billed/amount in the purchase order distribution will be reduced to below zero.

OR, When user tries to cancel a PO matched invoice, the error AP_INV_PO_CANT_CANCEL occurs:

APP-SQLAP-97150:  You cannot cancel this invoice because the cancellation would reduce the quantity or amount billed on one or more purchase orders to be less than zero.  We suggest you run the Matching Detail report for this invoice and the purchase orders to which it is matched in order to review the matching history.  This report can assist you in identifying negative-amount distributions that are matched to the same purchase order(s) as this invoice.


Steps to reproduce:

  1. Log into Oracle applications using a Payables responsibility.
  2. Open the Invoice Workbench
    (N) Invoices > Entry > Invoice
  3. Query a PO-Matched Invoice
  4. Try to Cancel the Invoice 
    Or Go to Invoice Lines and Discard one, note error
  5. Check quantity invoiced/amount invoiced in distributions
  6. Click on View Purchase order from Distributions
  7. Check quantity/amount invoiced on Purchase order distributions
  8. There is mismatch between Payables and Purchase order quantity/amount invoiced



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.