My Oracle Support Banner

ASN_ITEM Table Is Not Updated Properly After Closing The Partial Receipt of C Type ASN (Doc ID 2389620.1)

Last updated on MARCH 03, 2019

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.


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.