Order Base OMD Agent Fails When Shipment Is Allocated (Doc ID 1311671.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version: 6.2.0 to 6.2.2 - Release: 6.2 to 6.2
Information in this document applies to any platform.

Symptoms


When sending in an Order Base Update, if the shipment is allocated, the following error is received:

ERROR
-----------------------
2011-03-11 18:12:08.608 575114 Error Exception Cannot delete the ORDER_RELEASE record. A ALLOCATION_ORDER_RELEASE_D record references it in its ORDER_RELEASE_GID column.
java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (GLOGOWNER.FK_AORD_ORDER_RELEASE_GID) violated - child record found

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into OTM 6.1.
2. Send an updated order base via integration.
3. Note the Error in the logs:

2011-03-11 18:12:08.608 575114 Error Exception Cannot delete the
ORDER_RELEASE record. A ALLOCATION_ORDER_RELEASE_D record references it in its ORDER_RELEASE_GID column. java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (GLOGOWNER.FK_AORD_ORDER_RELEASE_GID) violated - child record found

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