Release 12 – Price Book

With R12, Oracle Advanced Pricing provides a robust self-service capability for users to generate and publish lists of products they sell with their related prices. The user has the ability to generate a Price Book showing list and net prices for a specific customer.

The Price Book can cross multiple price lists to derive the net price for a customer. Multi-currency price lists as well as formula pricing are included. Current, past or future effective pricing dates are supported. Input criteria can optionally include specific items, item category, pricing attributes, qualifiers and price lists.

The final price will be the list price with the adjustments and Freight and special Charges (This is different from the Sales Orders window where you can see the list price and adjustments). You can add textual information, images, and other data to
use as a catalog with specified effective dates.

The Price Book uses the customer item cross reference number (when available) rather than the internal item number, making it easy for the customer to identify their items. A Price Book can be generated for a customer or a Delta Price Book showing only items with changed prices can be created.

The publication options for the Price Book include printed report, online views, XML messages and email. Additionally, a Price Book API is provided for other applications to generate a price book and then use the information as required.

The feature is available in Basic and Advanced Pricing. Basic Pricing users have a subset of the full price book functionality.

Using the Pricing User responsibility, navigate to the Reports tab in the Advanced Pricing HTML Page. You can create a new Price Book or search for an existing one.

Click the Price Book Name in the search results table to view the Price Book details. You can print the Price Book from the window shown below:

The Price Book lines are categorized according to categories.