My Oracle Support Banner

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

Last updated on MAY 06, 2022

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

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
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.