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