My Oracle Support Banner

Poor Performance When Querying Order Number In Quick Ship Form (Doc ID 2886628.1)

Last updated on JANUARY 04, 2023

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
---------------

When querying Order Number In Quick Ship  or Shipping Transaction Forms, performance is poor returning results.


Find enviroment has fixed file versions for known performance issue documented in the following:

R12.2.x Shipping Transaction Form Performance Issue With the Order Number List of Values ( LOV ) (Doc ID 2850445.1)

forms/US/WSHSTREF.fmb 120.162.12020000.85
forms/US/WSHFSTRX.fmb 120.83.12020000.58
forms/US/WSHQSSUI.fmb 120.35.12020000.26

---------------------------------------------------------------------------------------------------------------------------

Poor performing query:




EXPECTED BEHAVIOR
-----------------------
Expect quick performance when querying in Order Number LOV.



STEPS
-----------------------
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

 

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.