My Oracle Support Banner

Querying The Price List Takes Lot of Time Because of Performance Issue (Doc ID 2630029.1)

Last updated on JANUARY 17, 2020

Applies to:

Oracle Advanced Pricing - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version, Price List

ACTUAL BEHAVIOR
---------------
Performance issue is being observed in the Price list form while querying the Price list header (%HW% , ctrl + F11), it takes too much time to populated the data. It takes couple of minutes for populating the data on price list page.

EXPECTED BEHAVIOR
-----------------------
Price List should get queried in Seconds. It should not take much time.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to Oracle Applications
2. Go to Oracle Pricing Manager Responsibility
3. Navigate to MENUPATH > Price Lists
4. Open the Price List Setup form.
5. Click on F11. Enter the Search Criteria as %HW% >> This %HW% is taken as an example. It can be any name.
6. Click on Ctrl + F11. It takes couple of minutes for populating the data on price list page.
 

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