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 03, 2019

Applies to:

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


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

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


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.