Searching Taking Long Time In Shipping Transaction Form WSHFSTRX (Doc ID 1583617.1)

Last updated on JULY 19, 2016

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

ACTUAL BEHAVIOR
---------------
After upgrading from 11.5.10 to R12.1.3, searching in Shipping transaction form by Mover order number (Pick Release Batch) is taking a long time to retrieve the results (5-10 mins)
Searching by order fields e.g. order number, is not an issue.

EXPECTED BEHAVIOR
-----------------------
Expect the search to take 1-2 mins

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. shipping transactions form > Lines
2. Enter pick release batch #, tab, find search takes 5-10mins


Changes

 upgrade from 11.5.10 to R12.1.3

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms