Advanced Pricing Build Attribute Mapping Rules Takes 2.5 Hours To Run (Doc ID 2802501.1)

Last updated on AUGUST 26, 2021

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
Build Attribute Mapping Rules Performance (Qp_Attr_Mapping_Pub) issue is occurring.
It takes over 2.5 hours to complete and this is causing serious performance issues.

EXPECTED BEHAVIOR
-----------------------
Expect to complete faster.

MOST EXPENSIVE STATEMENT
---------------------------------
SELECT 'Y'
FROM
QP_LIST_LINES A, QP_LIST_HEADERS_ALL 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



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Oracle Pricing Manager
2. Navigate: Reports
3. Build Attribute Mapping Rules > Run

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.