Generate Ship Units Action Does Not Delete Existing Ship Unit References (Doc ID 467848.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version: 5.5.03
This problem can occur on any platform.

Symptoms

-- Problem Statement:
On 5.5.03, When attempting to run the action, Generate Ship Units for an Order Release with a Ship Unit Reference number, the following error occurs:

ERROR
Cannot delete the SHIP_UNIT record. A SHIP_UNIT_REFNUM record references it in its [SHIP_UNIT_GID] column.

java.sql.SQLException: ORA-02292: integrity constraint (GLOGOWNER.FK_SUR_SHIP_UNIT_GID) violated - child record found

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. create order release using line item screen.
2. save order release.
3. edit order release and add ship-unit refnum.
4. change/add a Transport handling unit on line item.
5. Run action > Generate ship units.

-- Business Impact:
The issue has the following business impact:
Due to this issue, users cannot run the action Generate Ship Units for Orders with Ship Unit
reference numbers

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