After Applying RPC4 Query Consuming Time Is In Seeded Pricing Engine
Last updated on MARCH 28, 2018
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
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
See performance in the following sql:
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