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 MARCH 08, 2017

Applies to:

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

Symptoms

On : 11.5.10.2 version, Pricing Engine

ACTUAL BEHAVIOR
---------------
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.

EXPECTED BEHAVIOR
-----------------------
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.

STEPS
-----------------------
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.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Depending on type of configuration, it takes more than a Minute to do pricing for all lines.

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