My Oracle Support Banner

RCVRCRC While Creating A Receipt Against A BPR With ASN Error Total Quantity Exceeds Over Receipt (Doc ID 1936516.1)

Last updated on OCTOBER 28, 2019

Applies to:

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


On :  12.1.3 version, Receiving Functions

While creating a standard receipt against a BPR which has existing ASN lines,  get over receipt tolerance error "The total quantity exceeds the maximum over receipt tolerance" Although receipt quantity against the shipment line is zero  

Expected Behaviour
Oracle allows the user to receive either by ASN or by PO Number, if the Qty Ordered is 50, then the user should be able to receive 50 using ASN or PO, even if the ASN exists.

Customer has applied  patches 16307618:R12.PO.B and 18958511:R12.PO.B  per
<Note 428280.1> - ASN Receipts Fail With 'Total Quantity Exceeds the Maximum Over Receipt Tolerance'  
RCVRCERL.pll     version  120.38.12010000.77

Steps to Replicate

0.  Receiving Option - ASN Control Action
Set to  None: No error or warning is shown to the user if an attempt is made to receive a PO for which an ASN already exists.
1. Create PO with one line and one shipment for quantity of 50
      *** Shipment has over receipt tolerance 0%, reject action ***
2. Create an ASN for the PO for quantity 50
3. Purchase Order Shipments form shows for  PO at shipment level Quantity Received = 0
4. Perform the receipt in desktop for the PO Receiving / Receipts RCVRCERC form
Search for PO
See one line for the ASN (for quantity 50)
See one line for the PO (quantity 0)
5. Select the line for PO (quantity 0)
6. Save
7. The following error message appears:
      "The total quantity [50] exceeds the maximum over receipt tolerance that is set in purchasing. Please decrease the receipt quantity to less than or equal to [0]"

Line_Location_Id 3360906
Po_Header_Id 3268180
Po_Line_Id 3493282
Quantity 50
Quantity_Received 0
Unit_Meas_Lookup_Code 1 BOX
Po_Release_Id 108010
Qty_Rcv_Tolerance 0
Qty_Rcv_Exception_Code REJECT
Ship_To_Organization_Id 163
Shipment_Num 1  
Org_Id 81
Quantity_Shipped 50

-- over receipt tolerance is set to 0% REJECT and Quantity_Shipped = 50
In MTL_SUPPLY table there are ONLY records with SHIPMENT type

Customer would expect to not have any error message has in  Receiving Option - ASN Control Action
is set Set to  None: No error or warning is shown to the user if an attempt is made to receive a PO for which an ASN already exists.

Cancel the ASN (navigating to Receiving / Manage Shipments form) but mobile user do not know if there is an ASN
Or change the over receipt action  


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.