My Oracle Support Banner

Improve Performance in View Price Lists Form (Doc ID 2896699.1)

Last updated on SEPTEMBER 19, 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, Price List

ACTUAL BEHAVIOR
---------------

Price Lists Form is taking long to query with custom folder.

It takes 1 to 4 minutes to query with custom folder.

 

EXPECTED BEHAVIOR
-----------------------

Should take less than 1 min

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

1. Open Custom responsibility
2. Open form: View Price Lists
3. Query Name: %ABC% (f11/Ctr+f11)
4. Click on any Product Value and click on the folder icon



BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot work effectively

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
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.