Price Books feature is relatively new feature in R12. This functionality let you generate and publish price books to customers.

Price Books are of two types:

• Full Price Books: This price book contains the prices for all items
• Delta Price Books: This price book contains the additions & changes to prices since last full price book published.

Price Books can be published immediately or scheduled for publishing on a future date.
Price books can be published to EXCEL, RTF, PDF and XML formats. Published price books can be e-mailed, printed on a printer or XML message sent to a directory.

The important feature of price books is it can be based on one or more price lists, modifiers, pricing formulas, including multi currency price lists.

Important Price Book profile options are:

• QP: E-mail From Address: This profile option defines the from e-mail address for any e-mails that are sent from the price book feature.
• QP: External Default Pricing Perspective: This profile option sets the default pricing perspective for all external users.
• QP: Inbound XML Messaging Responsibility: This profile option defines the responsibility to be used for inbound XML messages.
• QP: Internal Default Pricing Perspective: This profile option sets the default pricing perspective for all internal users.
• QP: Pricing Perspective Request Type: This profile option defines the mapping between a Pricing Perspective (calling application) and the Request Type that it uses.

Pricing agreements can be deleted if they no longer required, but if pricing agreement is referenced in a sales order it cannot be deleted, instead its effective date can be changed to end date it.

Navigate to Oracle Pricing Manager responsibility -> Pricing Agreements

Delete Pricing Agreement

Navigate to top menu: View  -> Find
Select any one or multiple parameters to search existing pricing agreements.

Once you find the relevant pricing agreement

Navigate to top menu: View  -> Delete.

This action will delete the current pricing agreement that is opened. If there are any previous sales orders referenced by this pricing agreement then you will get error message.

Pricing agreements query screen is used to query existing pricing agreements.

Navigate to Oracle Pricing Manager responsibility -> Pricing Agreements
Navigate to top menu: View  -> Find

Query Pricing Agreements

Select any one or multiple parameters to search existing pricing agreements.

• Agreement name
• Agreement Number, Revision
• Invoice To
• Pricelist
• Customer
• Customer number
• Agreement type
• Contact person
• Invoice contact
• Sales Person

Click ‘ Find’ to see the matching pricing agreements.