"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:
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
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 |