PATTERN ENGINE LIMITATION Using Qualifiers Defined as Source Type = PL/SQL API Multi-Record (Doc ID 1642322.1)

Last updated on JULY 14, 2016

Applies to:

Oracle Advanced Pricing - Version 11.5.10 to 12.2.3 [Release 11.5 to 12.2]
Information in this document applies to any platform.
Advanced Pricing Pattern Engine

Symptoms

On : 11.5.10.2 version, Reports & Concurrrent Requests

ACTUAL BEHAVIOR
---------------
Order Entry has severe performance issues while entering lines when there are pricing engine calls.

The following query generates 3Gb of Undo Table Space


SQL_TEXT
----------------------------------------------------------------



EXPECTED BEHAVIOR
-----------------------
Not to generate huge temp space and performance to be very fast.


DISCOVERED
----------------

The pattern that is causing the problem centers around segment_id 100017 which maps to the buying group.
The first 8 segments are for that segment_id. The customers exhibiting the problems are assigned to multiple buying groups.
In this test customer, it is assigned to 7 buying groups, 6 of which have context with these qualifiers.
It appears that the combination of 11 segments, 8 of which are buying groups combined with a customer having 6 buying groups
to be considered is causing this massive result on the connect by.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Order Management Superuser
2. Navigate to: Orders, Returns > Enter Orders

 

NOTES
--------

Has already applied <patch 7364167> - MODIFIERS DO NOT WORK WHEN THE SAME 'NOT =' CONDITION QUALIFIERS ARE DUPLICATED

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, the order entry and shipping is completely stopped.

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