Suspect Unnecessary Context Built For Custom Pricing Attributes is being Executed For IGNORE Pricing Items Which Hinders Performance
(Doc ID 1599628.1)
Last updated on FEBRUARY 20, 2019
Applies to:Oracle Advanced Pricing - Version 220.127.116.11 and later
Information in this document applies to any platform.
On : 18.104.22.168 version, Pricing Engine
There are quite a few Custom Pricing/Qualifier attributes designed around business rules in the system which are mapped
to PL/SQL APIs for attribute sourcing. The issue is that these custom attributes are being sourced for
all sales order lines or Quote lines which are ignored by QP_CUSTOM_IGNORE pricing Hook.
Due to number of lines each configuration, the pricing engine performance is impacted.
Expect that for Custom or Seeded attributes sourced for lines that are being ignored by QP-CUSTOM_IGNORE that the
context is not built for these lines.
The issue can be reproduced at will with the following steps:
1. Responsibility: Order Management Super User (or equivalent)
2. Navigate to: Orders, Returns > Sales Orders
3. Create a Sales order, Add a PTO model in Lines, Launch configurator for the PTO models, choose required options and save configuration.
4. Notice delay in entry.
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