My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.