Shipping Transactions Form Takes Over 90 Seconds To Open; Also Slow When Querying Deliveries by Delivery Name
(Doc ID 2637987.1)
Last updated on MARCH 03, 2020
Applies to:Oracle Shipping Execution - Version 12.2.9 and later
Information in this document applies to any platform.
On : 12.2.9 version, Shipping Transactions form
Slow performance with Shipping Transaction Form as it takes 90 seconds to open.
Form is also slow when querying deliveries by delivery name
The following SQL was slow running:
The issue can be reproduced at will with the following steps:
1. OM Super User
2. Navigation > Shipping Execution > Transactions
3. Takes a long time for form to open
4. When querying deliveries by delivery name also slow
The issue has the following business impact:
Due to this issue, users must wait to use the shipping transactions form
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