My Oracle Support Banner

Shipping Transaction Form: Slow Performance When Updating Status On Delivery (Doc ID 2527550.1)

Last updated on DECEMBER 03, 2019

Applies to:

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

Symptoms

On : 12.1.3 version, Shipping Transactions form

Observing slow performance in Shipping transactions form when updating status on delivery

In Shipping Transactions form query a Trip.
Go to tab "Contents by Delivery"
Choose Actions--Close and press Go.
This action is getting stuck and is running for more than 15 minutes.
Then there is error message, about action cannot be performed, records are not eligable.
The error message is expected, but should come pretty immediately, when user try to perform such action.

DBA concluded that the query running is as follows:


Found bug 26101838, fixed file for R12.2  is WSHDEVLB.pls-120.35.12020000.19.  Need same fix for R12.1 


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
In Shipping Transactions form query a Trip.
Go to tab Contents by Delivery.
Choose Actions Close and press Go.
This action is getting stuck and is running for more than 15 minutes.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot must wait a long time to navigate in 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.