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 MARCH 08, 2017

Applies to:

Oracle Transportation Management - Version 6.1.7 and later
Information in this document applies to any platform.
***Checked for relevance on 14-Mar-2013***

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

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