ASN_ITEM Table Is Not Updated Properly After Closing The Partial Receipt of C Type ASN
Last updated on MAY 07, 2018
Applies to:Oracle Retail Warehouse Management System - Version 16.0 and later
Information in this document applies to any platform.
ASN_ITEM table is not updated properly after closing the partial receipt of C Type Advance Shipment Notice(ASN).
Steps To Recreate:
1. Create a Purchase order "CASN4" for item "ASN1" ,"ASN2" ,"ASN3" for 10 units each.
2. Create a C Type ASN "CASN4" with container_qty 4 for DC_DEST_ID "1".
2.1 ASN have 3 containers CASN411, CASN412, CASN413. Each container is multi-sku and have all 3 items ASN1, ASN2, ASN3 with unit_qty 1 each.
3. Create ASN Appointment. Print the receiving labels.
4. Receive only one containers CASN411.
5. Close the appointment.
There should be 6 lines in ASN_ITEM such that 3 lines updated with appt_nbr for the items/unit_qty received just now and other 3 line items with appt_nbr NULL for the unreceived units, however, there is only one line for the item 1"ASN1" for the unreceived units and there are no records created for the remaining 2 items for the unreceived units.
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 hundreds of Community platforms