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 FEBRUARY 21, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Price Book

ACTUAL BEHAVIOR
---------------
Find that when creating a price book for a price list that has 330000 price list lines, it takes more than 30 hours

EXPECTED BEHAVIOR
-----------------------
Pricebook Generate Program should complete in 30 mins

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Advanced Pricing Manager Resp -> Create Pricebook



Changes

 

Before this solution, it was not possible to generate only the Price Book data and to switch off Price Book document publishing.
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.

 

Cause

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