"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 JULY 20, 2024

Applies to:

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

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