Manage Pricing Lookups

Oracle Pricing comes predefined with the lookups that it displays in the Pricing Administration work area and in some of the Pricing pages of the Setup and Maintenance work area. You can't delete a predefined lookup, but you can modify some of their attributes.

Summary of the Setup

1. Examine the current behavior.

2. Modify the pricing lookup.

3. Test your set up.

Assume you must add a new value that you can use to specify the pricing strategy for a loss leader. You add this value to the Pricing Strategy Objectives lookup.

This topic uses example values. You might need different values, depending on your business requirements.

Caution: Modify a lookup only when the modification is critical to meet your business requirements. Most predefined lookups make sense in their predefined context and you shouldn't need to modify them, but if you do modify a predefined lookup, then you must make sure your modification doesn't affect Pricing logic. The example in this topic doesn't modify Pricing logic. It affects only your requirement to document how you use a pricing strategy. Some lookups are required. For example, the Customer Size attribute of a pricing profile is required. You can modify some of these lookups. If you aren't certain whether modifying a lookup will affect Pricing logic, then you must consult with Oracle before you make the modification.

Examine the Current Behavior

1. Go to the Pricing Administration work area.

2. On the Overview page, click Tasks > Manage Pricing Strategies.

3. On the Manage Pricing Strategies page, click Actions, and then click Create.

4. In the Create Pricing Strategies dialog, click the Objectives attribute, and notice that it displays these values.

   • Competitive pricing

   • Profit maximization

   • Revenue maximization

5. Click Cancel.

Modify a Pricing Lookup

1. Go to the Setup and Maintenance work area, then go to the task.

   • Offering: Order Management
   • Functional Area: Pricing
   • Task: Manage Pricing Lookups

2. On the Manage Pricing Lookups page, in the Search area, set one or more attributes to filter the search results, then click Search.

   For this example, set this value.

   Attribute	Value
   Module	Pricing Administration

3. In the Search Results area, scan the Meaning column for a lookup that describes the attribute you must modify.

   For this example, you modify the Pricing Strategy Objectives lookup.

4. Click the row that includes Pricing Strategy Objectives in the Meaning column.

5. In the Lookup Codes area, click Actions > New, then set the values.

   Attribute	Value
   Lookup Code	LOSS_LEADER
   Display Sequence	4
   Meaning	Loss leader
   Description	Business objective to stimulate sales for other, more profitable items

6. Modify the values in the Display Sequence column so it uses this sequence.

   Lookup Code	Display Sequence
   LOSS_LEADER	1
   ORA_COMPETITIVE_PRICING	2
   ORA_MAXIMIZE_PROFIT	3
   ORA_MAXIMIZE_REVENUE	4

7. Click Save and Close > Done.

Test Your Set Up

1. Go to the Pricing Administration work area.

2. On the Overview page, click Tasks > Manage Pricing Strategies.

3. On the Manage Pricing Strategies page, click Actions > Create.

4. On the Create Pricing Strategies dialog, click the Objectives attribute, then verify that it displays these values.

   • Loss leader

   • Competitive pricing

   • Profit maximization

   • Revenue maximization

5. Click Cancel.