Unable To Delete An Order Release Or Order Movement. Error: Can not perform this action because all the permanent order movements for an order are being deleted.
(Doc ID 1335250.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Transportation Management - Version 6.1.7 and laterInformation in this document applies to any platform.
Symptoms
On OTM version 6.1.7 When attempting to Delete an Order Release the following error is seen.
ERROR:
------
Error Exception Cannot delete the ORDER_RELEASE record. A ORDER_MOVEMENT record references it in its [ORDER_RELEASE_GID] column.
java.sql.BatchUpdateException: ORA-02292: integrity constraint (GLOGOWNER.FK_OM_ORDER_RELEASE_GID) violated - child record found
java.sql.BatchUpdateException: ORA-02292: integrity constraint (GLOGOWNER.FK_OM_ORDER_RELEASE_GID) violated - child record found
------
The above was traced to an Order Movement, when attempting to delete the Order Movement the following error was seen:
ERROR:
-----
Can not perform this action because all the permanent order movements for an order are being deleted. at sun.reflect.GeneratedConstructorAccessor691.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at glog.util.exception.GLException.factory(GLException.java:434) at glog.util.exception.GLException.factory(GLException.java:410) at glog.util.exception.GLException.factory(GLException.java:406) at glog.util.exception.GLException.factory(GLException.java:394) at glog.business.action.ordermovement.DeleteOrderMovementsAction.preValidate(DeleteOrderMovementsAction.java:224) at glog.business.action.ordermovement.DeleteOrderMovementsAction.delete(DeleteOrderMovementsAction.java:90) at glog.business.session.OrderMovementActionSessionBean.deleteOrderMovements(OrderMovementActionSessionBean.java:774) at
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Attempt to delete an Order Release.
2. Attempt to delete related Order Movement.
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 |