After Applying RPC4 Query Consuming Time Is In Seeded Pricing Engine (Doc ID 2140080.1)

Last updated on AUGUST 29, 2016

Applies to:

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

Symptoms


After applying RPC4 are seeing slowness in few concurrent program which includes seeded as well as custom programs. One of the critical custom report which is used for revenue reporting started running long after RPC4 patch application.
Running 'INTG Expiring Modifiers Pricing Report' program is having the performance issue.

The time taken for processing 3600 records is around 2 hours.
The current process is taking 2 hours against 10-15 minutes before RPC4 patch.

Based on analysis noticed that that query consuming time is in seeded Package QP_PREQ_GRP in Cache_Header_Qualifiers procedure(Attached the query).
The file version after RPC4 application is
/* $Header: QPXGPREB.pls 120.70.12010000.105 2016/01/13 17:22:08 jputta ship $ */

The file version beforeRPC4 application is
/* $Header: QPXGPREB.pls 120.70.12010000.78 2014/09/05 10:47:47 kdurgasi ship $ */

They use below APIs for getting list price

oe_oe_pricing_availability.pass_values_to_backend
oe_oe_pricing_availability.price_item

See performance in the following sql:



 

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