My Oracle Support Banner

qprunbld.sql Performance Issue (Doc ID 2834313.1)

Last updated on JANUARY 18, 2022

Applies to:

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

Symptoms

On : 12.2.9 version, Pricing Installation

ACTUAL BEHAVIOR
---------------
We are facing issue with qprunbld.sql while applying the patch 10124646
ORACLE E-BUSINESS SUITE RELEASE 12.2.0 [R12.2] UPGRADE DRIVER

EXPECTED BEHAVIOR
-----------------------
No performance issue

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. using adop, apply patch 10124646


AWR Report shows expensive query:

SELECT 'Y' FROM QP_LIST_LINES A, QP_LIST_HEADERS_B B WHERE ((A.BREAK_UOM_CONTEXT = :B2 AND A.BREAK_UOM_ATTRIBUTE = :B1 ) OR (A.ACCUM_CONTEXT = :B2 AND A.ACCUM_ATTRIBUTE = :B1 ) ) AND A.LIST_HEADER_ID = B.LIST_HEADER_ID AND B.ACTIVE_FLAG = 'Y' AND ROWNUM < 2



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.