Poor Performance When Query Price List Using F11

(Doc ID 2280447.1)

Last updated on SEPTEMBER 21, 2017

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
---------------
For R12.2.6 created price list, query in price list has poor performance.
If query an 11i created price list in form, good performance.



EXPECTED BEHAVIOR
-----------------------
Expect the same performance for R12.2.6 created price list as for an 11i price list

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Oracle Pricing Manager
Price Lists > Define
F11 query on R12.2.6 created price lists


Cause

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