Creating the Trade Transaction for a Shipment with Many Lines is Very Slow (Doc ID 2238279.1)

Last updated on FEBRUARY 27, 2017

Applies to:

Oracle Global Trade Management Cloud Service - Version 6.3.4 and later
Oracle Transportation Management - Version 6.3.4 and later
Oracle Transportation Management Cloud Service - Version 6.3.4 and later
Oracle Global Trade Management - Version 6.3.4 and later
Information in this document applies to any platform.

Symptoms

You have a scenario where a shipment has more than 3000+ lines on it.

When creating the transaction for this shipment, it is taking more than an hour to complete. While this is running it is holding a lock during execution and users aren't able to do anything with the locked shipment.

This is impacting the system performance too.

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