Last updated on JUNE 01, 2016
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
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)
7. The following error message appears:
"The total quantity  exceeds the maximum over receipt tolerance that is set in purchasing. Please decrease the receipt quantity to less than or equal to "
In PO_LINE_LOCATIONS_ALL see
Unit_Meas_Lookup_Code 1 BOX
-- 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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms