Multiple Orders Becoming Locked When Unassigning Order Releases Due to the Inclusion of Many Order Movements

(Doc ID 1356802.1)

Last updated on JULY 09, 2014

Applies to:

Oracle Transportation Management - Version: 6.1.0 to 6.1.6 - Release: 6.1 to 6.1
Information in this document applies to any platform.

Symptoms


When unassigning an Order Release, OTM is including all distantly related orders and shipments. In a complex planning scenario, this can result in a very large join and cause potential performance problems.

As a result, the Order Release (and all related order releases) can become locked and unavailable for other actions.

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