My Oracle Support Banner

R12.1.x Poor Performance Shown While One Generates a Price Book (Doc ID 2378633.1)

Last updated on FEBRUARY 25, 2019

Applies to:

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

Symptoms


ACTUAL BEHAVIOR
We took 2 samples of data. One generating price book from a price list that has 2200 lines and other one for price list having 6000 lines
and then comparing with the run of a price book in production that has around 78000 lines.
The run times were 5 minutes for 2200, 20 minutes for 6000 and around 11 Hrs for 78000(production).

Most expensive statement(s) Shown
SQL ID : 4x9fj5025y4x2 (below) took 8 hours in production



STEPS
The issue can be reproduced at will with the following steps:
1. Generate price book


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.