My Oracle Support Banner

R12 AP: Quantity Billed Exceeds Quantity Received Hold (QTY REC Hold) Placed While Validating Invoices Which Are Imported From Interface. (Doc ID 2970926.1)

Last updated on AUGUST 30, 2023

Applies to:

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


After importing a Purchase order matched invoice through the open interface import program, quantity received hold is placed on the invoice during validation.

Hold Name :  Quantity Billed Exceeds Quantity Received Hold (QTY REC Hold).

The issue can be reproduced at will with the following steps:

  1. Insert Purchase order matched invoice details into AP interface tables - ap_invoices_interface/ap_invoice_lines_interface using loader program.
  2. Quantity_invoiced is NULL in ap_invoice_lines_interface
  3. Oracle Payables Responsibility  > Other > Requests > Run> Submit the Payables Open interface import program.
  4. After Import of Invoice > Invoice > Entry > Invoices >Actions> Validate  
  5. Go to Invoices > Hold tab and see that hold got placed on invoice while validating :  Qty Rec: Quantity Billed Exceeds Quantity Received Hold 




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.