My Oracle Support Banner

Shipping Transactions Form Takes Over 90 Seconds To Open (Doc ID 2637987.1)

Last updated on OCTOBER 25, 2023

Applies to:

Oracle Shipping Execution - Version 12.2 and later
Information in this document applies to any platform.

Symptoms


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


Changes

 

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
Changes
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.