My Oracle Support Banner

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.

Symptoms

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:


STEPS
-----------------------
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
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users must wait to use the shipping transactions form

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.