Pricing Rules

Set up a pricing rule to control how Oracle Pricing calculates the price for each item.

A pricing rule is a statement that controls how Pricing applies a price adjustment on an item. For example, how to apply a discount on the list price of an item.

You add a pricing rule when you create a list, such as a price list.

Apply more than one charge to an item. For example, create a charge for a one-time sales price for a desktop computer in one pricing rule, then apply another charge for the maintenance service that recurs monthly in another pricing rule.
Create a rule that calculates the base price, list price, price adjustment, discount, return charge, shipping charge, and so on according to a set of conditions and results.
Create a currency conversion rule that manages price for a currency.

A pricing entity is an object that stores the details that Pricing uses to price an item. A pricing strategy, pricing segment, customer pricing profile, price list, cost list, and discount list are each an example of a pricing entity.

You can apply a rule to a pricing entity.

Pricing Entity	Example Rule	Get Details
Price list	Set the base price to $500 USD for a cell phone, and allow you to manually adjust the price.	Manage Price Lists
Cost list	Add a 5% increase to the invoice price to capture cost of goods sold.	Manage Cost Lists
Discount list	Provide an 8% discount if the customer purchases a recurring service for 12 months, such as a monthly service call on a commercial kitchen appliance.	Manage Discount Lists
Shipping charge list	Price shipping for a Desktop Computer at $50 for Standard Delivery and $100 for Express Delivery.	Manage Shipping Charge Lists
Currency conversion list	Specify the base price for a computer monitor at $400 USD (United States Dollar), and use a 1.38 conversion rate to offer it for sale in CAD (Canadian Dollar) at $553.88.	Manage Currency Conversion Lists

Guidelines

You use a separate page to specify each type of pricing list. For example, you use the Manage Price Lists page to specify a price list.
The Overview page of the Pricing Administration work area displays pricing rules that you recently updated. You can search it to locate other pricing rules.
You must click Approve on the page that you use to create the list so you can add it to a pricing strategy and so the pricing algorithm can use it.

Use can sign in with Oracle Pricing's or Oracle Order Management's administrative privileges to edit a pricing rule. However, Pricing will display Approve only if you sign in with pricing privileges, and only if you didn't already approve the list.
You can set up a list, add it to a pricing strategy, and then verify your work. The behavior is similar for any type of list that you create. For details, see Manage Pricing Strategies.
You can create a tier pricing rule that adjusts price according to the number of items that the customer orders. For example, apply a 10% discount on all items when the customer buys two or three computers, and apply a 15% discount on all items when the customer buys four or more computers. For details, see Adjust Price for Pricing Rules.
Add a pricing matrix. Use it to adjust the charges that you specify in each list according to a set of conditions and the value of an attribute. For details, see Adjust Price for Pricing Rules.
You use the Edit Rules Table Columns action to edit a rule, such as the rule's conditions.
If your rule references another object, then you can't use Edit Rules Table Columns to delete a part of the rule. You must first remove the reference, and then do the delete. For example, assume you want to delete a condition column from an assignment rule, the column references the Cost List Charge Adjustment matrix type. You must first delete the reference to the matrix type, and then delete the condition column.

Access Set

You must click Access Set when you create a list, and then add an access set.

The access set identifies the sales orders that Pricing will process. For example, if you select Vision Operations Business Unit Set for the access set, then Pricing will only process sales orders that reference the Vision Operations business unit.

Set the Access Set attribute to Common to process sales orders for all business units.

Create Duplicate Lists

Copy list details to a new list, including pricing rules, modify the new list, then save your modifications. Copying a list helps you create a new list and avoid errors. You click the Duplicate icon to duplicate a list.

For example:

Go to the Pricing Administration work area, then click Tasks > Manage Discount Lists.
Search for the list you must copy.
In the Search Results area, click Duplicate.

Use the dialog that displays to specify how to copy the list, such as whether to copy discount lines from the original discount list.

Note

If you modify the currency when you duplicate a list, then you might not be able to copy the charges that the original list references.

For example, assume you duplicate a cost list and modify the currency to CAD (Canadian Dollar). You might not be able to copy the charges because Pricing created them for some other currency, such as USD (United States Dollar).
If you duplicate charges, then you can copy all charges or only the most current set of charges.

Examine Old Pricing Rules

The Overview page in Pricing Administration comes predefined to display pricing rules that you recently updated. You can also search for older pricing rules that have expired or are about to expire.

Go to the Pricing Administration work area, then click Search > Advanced.
On the Search Pricing Rules page, in the Advanced Search area, set the values, then click Search.
In the search results, use Rule End Date to filter the results, such as Before 12/28/19 12:00 AM.