My Oracle Support Banner

ASN / ASBN Can Be Over Received Quantity_Received > Quantity_Shipped In RSL Although Over Receipt Tolerance Set to Reject (Doc ID 1582971.1)

Last updated on APRIL 12, 2018

Applies to:

Oracle Inventory Management - Version 11.5.10 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.

Symptoms

Find that after receiving ASBN container (using shipment number ) on Enter Receipts form duplicated receiving happened in the system
even though the over receipt tolerance is set to 0 / REJECT value.

In RCV_SHIPMENT_LINES table QUANTITY_RECEIVED is superior to QUANTITY_SHIPPED.

Receiving data collection script shows for instance

PO_LINE_LOCATIONS_ALL

Line_Location_Id 225692
Po_Header_Id 133813
Quantity 71994
Quantity_Received 66274
Qty_Rcv_Tolerance 0
Qty_Rcv_Exception_Code REJECT


RCV_SHIPMENT_HEADERS

Shipment_Header_Id 48632061
Receipt_Source_Code VENDOR
Shipment_Num 78776
Receipt_Num 11286
Asn_Type ASBN


RCV_SHIPMENT_LINES
some lines including 

SHIPMENT_LINE_ID 55405678
SHIPMENT_HEADER_ID 48632061
QUANTITY_SHIPPED 4290
QUANTITY_RECEIVED 8580
SHIPMENT_LINE_STATUS_CODE FULLY RECEIVED
SOURCE_DOCUMENT_CODE PO
PO_HEADER_ID 133813
PO_LINE_LOCATION_ID 225692
ASN_LINE_FLAG Y

RCV_TRANSACTIONS
some lines including for SHIPMENT_LINE_ID 55405678

Transaction_Id Request_Id Program_Update_Date Transaction_Type Transaction_Date Quantity Unit_Of_Measure Shipment_Header_Id Shipment_Line_Id User_Entered_Flag Destination_Type_Code Parent_Transaction_Id
89236469 161368665 08-24-2013 14:02 RECEIVE 08-24-2013 14:01 4290 Kilogram 48632061 55405678 Y RECEIVING -1
89236470 161368665 08-24-2013 14:02 DELIVER 08-24-2013 14:01 4290 Kilogram 48632061 55405678 N INVENTORY 89236469

89236478 161368670 08-24-2013 14:02 RECEIVE 08-24-2013 14:01 4290 Kilogram 48632061 55405678 Y RECEIVING -1
89236479 161368670 08-24-2013 14:02 DELIVER 08-24-2013 14:01 4290 Kilogram 48632061 55405678 N INVENTORY 89236478

 There are duplicate receive / deliver transactions for the same receipt number / ASN Shipment Number / same shipment line.


Expected Behavior
Over receiving should not be allowed for ASBN shipment lines

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.