My Oracle Support Banner

"Cannot delete the SHIP_UNIT_LINE_T record. A S_SHIP_UNIT_LINE_T record references it in its SHIP_UNIT_GID, SHIP_UNIT_LINE_NO column" Error When Using EDIT - SHIPMENT OMD or PROPAGATE CHANGES (Doc ID 2522634.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Transportation Management Cloud Service - Version 18 and later
Information in this document applies to any platform.

Symptoms

When using OMD EDIT SHIPMENT, or PROPAGATE CHANGES, when trying to remove a ship unit from one order release the following error is seen:

Error Exception  Cannot delete the SHIP_UNIT_LINE_T record. A S_SHIP_UNIT_LINE_T record references it in its SHIP_UNIT_GID, SHIP_UNIT_LINE_NO column.
java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (GLOGOWNER.FK_SSUL_SHIP_UNIT_LINE) violated - child record found

 

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!

In this Document
Symptoms
Cause
Solution
References


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