My Oracle Support Banner

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 11.5.10.0 to 11.5.10.3 [Release 11.5.10]
Information in this document applies to any platform.
OEXOEORD.fmb

Symptoms

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.

EXPECTED BEHAVIOR
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.

Changes

Only know patch applied was for Localizations, and should not have been related:
<Patch 4244829> for localization for ref. not affecting base 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
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.