New Price Book Option Created to Improve Poor Performance of Price Book Which Has 330,000 Price List Lines
Last updated on FEBRUARY 08, 2018
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.
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