New Price Book Option Created to Improve Poor Performance of Price Book Which Has 330,000 Price List Lines
(Doc ID 1584271.1)
Last updated on APRIL 03, 2019
Applies to:Oracle Advanced Pricing - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Price Book
Find that when creating a price book for a price list that has 330000 price list lines, it takes more than 30 hours
Pricebook Generate Program should complete in 30 mins
The issue can be reproduced at will with the following steps:
1. Advanced Pricing Manager Resp -> Create Pricebook
With this fix, a new option 'Immediate, Generate Only Data' is added in drop down Publish, within the Publishing options section,
of the Create Price Book page. If this option is selected, then the Price Book document will not be published and only the
Price Book data will be generated in Price Book related database tables. This will reduce the time taken by a Price Book request.
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