Sales Order Screen Lov Take 4 Min When Using Bill To Lov
(Doc ID 378276.1)
Last updated on FEBRUARY 04, 2020
Applies to:Oracle Order Management - Version 220.127.116.11 to 18.104.22.168 [Release 11.5.10]
Information in this document applies to any platform.
Find when navigating in the Sales Order form and using the Bill To Location field for a Partial Value (not just %), get very poor performance of over 4 minutes to return values.
Expect almost immediate response on partial select. (Letter + %)
STEPS TO REPRODUCE
1. Click into the sales Order field for Bill To Location.
2. Click the LOV
3. Enter a partial value, such as 'P%' and hit find.
4. Takes over 4 minutes to return results.
5. Just clicking the '%' returns all rows very quickly also. Only Partial Select query is poor.
Only know patch applied was for Localizations, and should not have been related:
<Patch 4244829> for localization for ref. not affecting base form
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