Shipment Unassign Shipment Stop Refnum Data Consistency Issues (Doc ID 1532896.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

The SHIPMENT_STOP_INV_PARTY and SHIPMENT_STOP_REFNUM data is corrupted for Multistop shipments when an order from a stop in the middle of the shipment is unassigned.

Steps to Replicate:

1. Create a Multi Stop Shipment (at least 4 stops)
2. For each shipment stop, add a REFNUM and update INVOLVEDPARTY contact
  (Make Sure this are different values to see the difference in results)
3. Unassign orders related to any stop other than the very last stop (select all the orders for a stop)
4. Verify the REFNUM and INV PARTY on the remaining stops after unassignment

You will notice that there are still three Remarks and "STOP 4 is repeated. There should only be two remarks. Note: repeating the same test case using a Reference Number instead of Remark, works fine.

Cause

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