Price Book R12 feature

Price Book is another new feature offered in R12 Advance pricing Module of Oracle Application.

Price Book is a new feature that allows customer to generate and publish lists of products with their related prices.

These prices are generated for a full or delta price book. Multiple publishing options are available.  This powerful tool will help provide greater insight to help ,manage and maintain overall pricing strategy.

Price Book is a new Pricing report that displays item list and net prices (for a specific customer) based on a specific pricing date.
Within the price book, you can view details of the

•   List price,
•   Discounts,
•   Surcharges,
•   Price breaks, and
•   Freight and special charges.

The price book supports formula based prices, and Customer Item/numbers are also visible within the price book.

The Price book accepts various inputs for the price calculation.  These inputs include

•    Pricing effective date.
•    Pricing attributes.
•    Qualifiers.

It also taken into consideration

•    Pricing Perspective (request type),
•    Currency,
•    Customer,
•    Customer (account) number,
•    Operating unit,
•    Pricing effective date,
•    Quantity, product(s) etc

You can create two types of price books.

A full price book contains all items and associated prices as of a specific pricing effective date.

The Delta Price Book is generated as of a new pricing effective date, and displays any deltas in items or prices with respect to the Full price book of the same name, for the same customer and with all other input criteria remaining the same.

Multiple publishing options are available after the price book is generated , and these are e-mail, print, XML message, View Document and via API.

Price Books are supported in Basic and Advanced Pricing.

Price Book Request:

A price book can be requested via the

•    Price book HTML UI,
•    XML Message, or
•    Price Book API.

Then the user specifies the criteria for generation (such as pricing calculation criteria like quantity, items, currency) because behind the scenes, a pricing engine call is made to search across all your pricing setups to generate the price book.
Once a price book is generated we have lot of output options like view/print/email as shown below.
Advanced Pricing provides the following public APIs for the price book feature:

•     Create Price Book API and
•     Get Price Book API.

Applications integrated with Advanced Pricing can call these APIs to generate or retrieve a price book.

API
QP_PRICE_BOOK_PUB.Create_Publish_Price_Book
QP_PRICE_BOOK_PUB.Get_Price_Book

Advantages –

•     Increase Insight
•     Help in monitoring the price changes for a ct. from time to time.

Set Up –

•     Set the Profiles  -
•     Make sure Seeded Parameter are set for price Book
•     Setup your Printer (optional)
•     Setup XML Publisher /XML Gate way

For Profile options and parameters please refer user guides.

Note – Delta can be executed only after the Full price book has created.
Publish your price book.
Republish your price book. Publishing options are email/print/XML.

For More details, or if you want to Integrate your custom application with Advance pricing and want to use Price Book API feel free to contact us