Process UPS Upload Batch Is Not Deleting the Received Cartons from the System (Doc ID 2212806.1)

Last updated on DECEMBER 15, 2016

Applies to:

Oracle Retail Warehouse Management System - Version 15.0.1 and later
Information in this document applies to any platform.

Symptoms

After running the process_ups_upload, the PO Containers are not getting purged from the CONTAINER and CONTAINER_ITEM table.


Steps to Recreate:

1. Create a unit pick system code 'HUS'.
2. Create unit_pick_zone.
3. Assign items to unit pick system code 'HUS'.
4. Create a pre-dist purchase order.
5. Allocate to more than one store.
6. Create appointment and receive the PO.
7. Verify ALLOCATION_DATA table is populated (print the labels).
8. Verify INBOUND_CARTON got populated (receive labels).
9. Populate PROCESS_UPS table to fulfill the allocations.
10. Execute process_ups_upload script and notice that PO cartons are still available and quantity is not decremented.

Cause

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