"ORA-01407: cannot UPDATE ("GLOGOWNER"."ORDER_MOVEMENT"."ORDER_MOVEMENT_GID") TO NULL" Error Message While Running Archiving And Purging Job In OTM (Doc ID 2100577.1)

Last updated on FEBRUARY 05, 2016

Applies to:

Oracle Transportation Management - Version 6.3.7 to 6.4.0 [Release 6.3 to 6.4]
Information in this document applies to any platform.

Symptoms



While running Archiving and Purging Run by invoking PKG_PURGE package, the following error occurs.


ORA-01407: cannot
UPDATE ("GLOGOWNER"."ORDER_MOVEMENT"."ORDER_MOVEMENT_GID") TO NULL
UPDATE ORDER_MOVEMENT a
SET ORDER_MOVEMENT_GID= NULL
WHERE EXISTS
  (SELECT 'X'
  FROM ORDER_MOVEMENT b,
  purge_data c
  WHERE b.ORDER_MOVEMENT_GID = a.ORDER_MOVEMENT_GID
  AND b.rowid = c.data_rowid
  AND c.table_name = 'ORDER_MOVEMENT'
  )


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Archiving and Purging Run by invoking PKG_PURGE package



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