Opening Price List/Modifier Form Having Performance Issues in QP_SECU_LIST_HEADERS_VL (Doc ID 2043623.1)

Last updated on FEBRUARY 23, 2017

Applies to:

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

Symptoms

On : 12.2.2 version, Pricing Engine

ACTUAL BEHAVIOR
---------------
Performance of Pricing Module is extremely slow. Querying up a Price List and querying up a Modifier takes a very long time.

EXPECTED BEHAVIOR
-----------------------
Expect the price list/modifier to only take seconds to open after query.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Oracle Pricing Manager
2. Open up the price list or modifier setup form
3. Query for a price/modifier list
-- Takes a long time, about 2 min for price list --

Issue Verified:

Review of the initial trace reveals poor performance in

MO_GLOB_ORG_ACCESS_TMP and QP_SECU_LIST_HEADERS_VL

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