My Oracle Support Banner

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

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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