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.
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
The issue can be reproduced at will with the following steps:
1. Generate price book
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