Oracle Transportation Management (MOSC)

MOSC Banner

java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (GLOGOWNER.FK_SSU

edited Nov 6, 2019 4:07AM in Oracle Transportation Management (MOSC) 5 commentsAnswered ✓

Hi,

I´ve a problem when i try delete a order release from OTM(6.3.7)

It not happens to all order releases, just in some. We´re trying delete from the OTM, so the delivery not avaliable more in the OM so send again to OTM to remove from OTM

So when we try delete some order releases, return the exception:

delete from ship_unit_line where ship_unit_gid=? and ship_unit_line_no=?

delete from ship_unit_line where ship_unit_gid=? and ship_unit_line_no=?;  [OTMPRD.60841935, 1] 
Cannot delete the SHIP_UNIT_LINE record. A S_SHIP_UNIT_LINE record references it in its [SHIP_UNIT_GID, SHIP_UNIT_LINE_NO] column.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center