Query in Price List Form QPXPRLST with Product Value is Taking Long Time. (Doc ID 2097054.1)

Last updated on JANUARY 14, 2016

Applies to:

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


After upgrading the instance from 11i to R12. When searching Price list with product value, its taking 10+ seconds in R12. This issue is not there in the existing 11i system and only takes 1-3 seconds.

Expect query in R12 to take 1 - 3 seconds.


1. Responsibility: Order management Super User &/or Pricing Manager
2. Navigate: Price Lists > Query data in the price list form
3. Notice query takes 10+ seconds in R12, R11i takes 1-3 seconds for same data.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms