My Oracle Support Banner

Pattern Based Searching Logic in Pricing Engine For Performance Improvement (Doc ID 948900.1)

Last updated on MAY 19, 2021

Applies to:

Oracle Advanced Pricing - Version 11.5.10 and later
Oracle Order Management - Version 12.2.9 to 12.2.9 [Release 12.2]
Information in this document applies to any platform.
Authors: Shankar Kattamanchi, Rajendra Badadare, Krishna Durgasi, Deepak Nema, and Kelli Stone


If one is experiencing a performance issue and would like check to see if this new functionality would be applicable for the situation, please log a Service Request. We will then check for existing solutions and make recommendations as appropriate.

Oracle Applications 11.5.10 and beyond implements a new pattern based searching logic in the Pricing Engine. This change is purely to improve performance of the pricing engine. It does not alter any pricing functionality. It will help with better performance in all pricing flows with much improved search time.  This functionality is available for both Advanced Pricing and Basic Pricing users.

Release 11.5.10: <Patch 12982974>

Release 12.0: <Patch 8933551> - 8933551:R12.QP.A 
Release 12.1.1: Need both patches - unpublished Patch 9210767:R12.QP.B
                          and unpublished Patch 9326971:R12.QP.B
                          On Release 12.1.1: Need Service Request to get patches.
Release 12.1.2 and beyond: Included


Traditional Engine Search Routine Performance Problem:
Pricing setup is very flexible with attribute management, which provides one sample opportunity to fit their business needs. The pricing engine needs to look for all combinations and permutations to get the appropriate price lists and modifier lines eligible for the incoming line. Since all the attributes (pricing, product and qualifier) for price lists and modifier lines are optional its challenging to decide the best search selectivity path to suit each specific business setup.


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
 Solution Pattern Engine:
 Profile Controlled
 How to Uptake Pattern Search?
 Deciding Search Path using Time Log
 How to take Time Log?
 Time Log example:
 Time Log interpretation: 
 Deciding on Best Search path using Time Log

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.