Poor Performance When Querying Order Number In the Quick Ship Form and/or the Shipping Transaction Form (Doc ID 2886628.1)

Last updated on AUGUST 21, 2024

Applies to:

Symptoms

Querying Order Number in the Quick Ship or Shipping Transaction Forms has poor performance returning the results.
Poor performing query is identified below:

Expects quick performance when querying in the Order Number LOV.



The issue can be reproduced at will with the following steps:

1. Order Management Super User Responsibility
2. Shipping
3. Navigate to Quick Ship Form and/or Shipping Transaction Form.
4. Query - > Select Order Management from Source System.
5. Go to Order Number LOV.
6. Click the LOV.
7. Enter '%' and click find.
8. Order Numbers retrieved slowly.

Changes

Already had applied patch 33819012:R12.WSH.C for Shipping Transaction Form performance issues and have the following fixed file versions:

WSHFSTRX.fmb 120.83.12020000.58
WSHQSSUI.fmb 120.35.12020000.26
WSHSTREF.fmb 120.162.12020000.85

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.