Oracle Apps Order Management - Overview of Price Lists

Price lists are essential to ordering products because each item entered on an order must have a price. Each price list contains basic list information and one or more pricing lines, price breaks, pricing attributes, qualifiers, and secondary price lists. Basic information includes the price list name, effective dates, currency, pricing controls, rounding factor, and shipping defaults such as freight terms and freight carrier.

Note: You can only view or update a price list in your pricing transaction entity. The profile QP: Pricing Transaction Entity must match the pricing transaction entity of the price list.You can only view or update a price list in your source system. The profile QP: Source System Code must match the source system of the price list. Otherwise, the price list is view-only.The profile option QP: Selling Price Rounding Options affects the rounding of adjustments. For more information on this and other profile options, see: Oracle Advanced Pricing Implementation Manual, Profile Options.

Effective Dates

Price lists can have starting and ending dates. This allows you to prepare price lists ahead of when they are valid and to ensure they will not be used until their start dates.

Inactive Price Lists

You can temporarily or permanently inactivate a price list using the Active check box. Once a price list is inactivated, you can still do the following:

• Query the inactive price list: In query mode, the check box is enabled, but the underlying value is null. To retrieve only inactive price lists, unable the check box; to retrieve only price lists that are active, unable the check box, then select it.
• Update it.
• Base a formula on an inactive price list.

Note: The pricing engine does select inactive price lists when doing a pricing request. Other applications can call an inactive price list and use relevant information.

Price List Currency

If you have international sales, you can record transactions in different currencies by defining a price list for each currency. After entering the currency for an order or return, you must choose a price list in the same currency.

Rounding Factor

You can define the number of places to the right or left of the decimal point to which the pricing engine rounds prices from price lists and modifiers from modifier lists:

• a negative rounding number such as -3 rounds the number of characters to the right of the decimal point. For example, a rounding factor of -3 indicates rounding to the nearest thousands so 1.1445 rounds to 1.145.
• a positive rounding number such as +2 rounds the number of characters to the left of the decimal point. A rounding factor of 2 indicates rounding to the nearest hundreds so 107 rounds to 100.
• If you enter zero, you affect nothing

Note.: You can limit the rounding factor value by the number of positions you specify in the extended precision format of the price list's currency. For more information, see Oracle Advanced Pricing Implementation Manual, Profile Options QP_UNIT_PRICE_PRECISION_TYPE.

Secondary Price Lists

The pricing engine uses secondary price lists when it cannot determine the price for an item using the price list assigned to an order. Primary and secondary price lists have the same currency.

If the item that you are ordering an item is not in the primary price list, the pricing engine uses the highest-precedence secondary price list (the secondary price list with the lowest value for the precedence field).

If an item appears on both the primary and a secondary price list with the same effective dates, the pricing engine uses the primary price list to price the item. If an item appears on the primary price list but is not active (the effective end date has passed), the pricing engine uses the price on the secondary price list.

Agreement Price Lists

Oracle Advanced Pricing allows you to establish agreements with your customers that define the prices, payment terms, and freight terms that you negotiate.

There are two methods by which you can manage agreements:

• Standard agreements which use standard price lists (PRL)
• Pricing agreements which use agreement price lists (AGR)

Defining Price Lists

Price lists contain item and item category prices. You can define and maintain multiple price lists.

You can define the following types of prices on price lists:

• Unit price: A fixed price.
• Percent Price: A price which is a percent of the price of another item.
• Formula: Multiple pricing entities and constant values related by arithmetic operators. For example, you define the price of an item to be a percentage price of another price list line.
• Price Break: If the price of an item varies with the quantity ordered, you can define bracket pricing or price breaks. The following table illustrates a price break:

Table: Price Breaks

Attribute	Value	Value From	Value To	Price
Item Number	A11111	1	11	50
Item Number	A11111	12	<all 9's>	45

There are two types of price breaks:

• Point: The pricing engine retrieves the absolute price that brackets the attribute.
• Range: The pricing engine computes the price based on the range of price breaks defined, starting from the lowest value of the price related to the attribute.

You must enter both Value From and Value To. To create no upper limit, enter all 9's in Value To. You cannot overlap ranges between the price ranges of price break; for example, if one price range is from 1 to 11, you cannot have another price range that is 5 to 20.

If you define a price break for an item category, all the items within the category are eligible for the price break.

Qualifier Grouping Number Options

You can attach both qualifiers and qualifier groups to price list lines. When you attach qualifier groups, you are attaching all of the qualifiers in the qualifier group. The qualifier grouping number is important when you attach multiple qualifiers because it indicates to the pricing engine how to evaluate the qualifiers:

• Qualifiers with the same grouping number are evaluated as a boolean AND condition (an entity must meet all of the conditions to qualify).
• Qualifiers with different grouping numbers are evaluated as a boolean OR condition (an entity must meet one of the conditions to qualify).

Before you attach multiple qualifier groups, you must indicate how the process should coordinate the grouping numbers. You select one of the following grouping number options:

• Retain Grouping Numbers Across Qualifier Groups: The grouping numbers of each attached qualifier remains as it appears in its qualifier group. In this case, the collection of attached qualifiers does not mirror the AND and OR combinations within each of the original qualifier groups.
• Generate Unique Grouping Numbers Across Qualifier Groups: The process maintains the AND and OR combinations within each of the original qualifier groups and then create OR conditions between the groups. It attaches the first qualifier group with grouping numbers as is, then finds the highest grouping number used, increases it by one, and increases all of the grouping numbers of the second group by this number. It attaches subsequent groups in the same manner, using the highest grouping number used by the just previously attached group.
• Both: If you attach qualifiers using one option and then re-access the window and attach additional qualifiers using the other option, the second round qualifiers attach differently depending on the option. If the second round option is Retain Grouping Numbers Across Qualifier Groups, the process attaches those qualifiers among the already existing qualifiers. If the second round option is Generate Unique Grouping Numbers Across Qualifier Groups, the process begins attaching groups using grouping numbers incremented from the highest existing grouping number.
• Several tables that follow show how the process sets the grouping numbers when you use each option. The following table shows the sample qualifier groups for these examples and, after the table, the text clarifies how to translate the table information into qualifier logic:

Table: Selected Qualifier Groups

Qualifier Group	Qualifier	Qualifier Grouping Number
G1	Q1	1
G1	Q2	2
G1	Q3	2
G1	Q4	3
Null	Null	Null
G2	Q5	1
G2	Q6	1
G2	Q7	1
Null	Null	Null
G3	Q8	1
G3	Q9	2
G3	Q10	3

The grouping numbers within group G1, for example, create the qualification that the entity qualifies if it meets condition Q1 OR (condition Q2 AND condition Q3) OR condition Q4.

The following table shows the results of combining the sample qualifier groups using the option Retain Grouping Numbers Across Qualifier Groups. The table emphasizes the combination of qualifiers from different qualifier groups into the same qualifier grouping number:

Table: Option: Retain Grouping Numbers Across Qualifier Groups

Qualifier Group	Qualifier	Qualifier Grouping Number
G1	Q1	1
G2	Q5	1
G2	Q6	1
G2	Q7	1
G3	Q8	1
Null	Null	Null
G1	Q2	2
G1	Q3	2
G3	Q9	2
Null	Null	Null
G1	Q4	3
G3	Q10	3

The following table shows the results of combining the sample qualifier groups using the option Generate Unique Grouping Numbers Across Qualifier Groups. The table emphasizes the preservation of each qualifier group with recalculation of qualifier grouping numbers:

Table: Option: Generate Unique Grouping Numbers Across Qualifier Groups

Qualifier Group	Qualifier	Qualifier Grouping Number
G1	Q1	1
G1	Q2	2
G1	Q3	2
G1	Q4	3
Null	Null	Null
G2	Q5	4 (3 + 1)
G2	Q6	4 (3 + 1)
G2	Q7	4 (3 + 1)
Null	Null	Null
G3	Q8	5 (4 + 1)
G3	Q9	6 (4 + 2)
G3	Q10	7 (4 + 3)

Creating a Price List

To create a price list:

1. Navigate to the Price Lists window.

2. Enter a price list Name.

3. Select the Mobile Download box if you are using an Oracle Mobile application and want to download specific price lists onto a mobile device such as a laptop computer or hand-help scanning device.

The default value is No (disabled).

4. Determine the status of the price list:
• Inactive: Active box is cleared.
• Active: Active box is selected.

Note: When in initiating query mode functionality within the Price list window, the Active box will appear selected (checked) but the underlying value is Null. If you wish to query for price lists that are active, you must first de-select the Active box, then reselect it.

5. Enter a description of the price list in Description.

6. Enter the price list currency in Currency.

7. Enter a rounding factor to be applied to the price list in Round To.

A positive number indicates number of places to the left of the decimal point; a negative number indicates number of places to the right of the decimal point. The default is -2. The Round To value entered in the price list is used to store the rounded value for storing and the precision type for displaying list price.

Oracle Pricing rounds the base price and all discount amounts before using them in calculations.

Note: The Round To value in the Price Lists window cannot be updated if the profile option QP: Unit Price Precision Type is set to Enforce Currency Precision.

The following example provides different scenarios different values display for price list depending on how the profile option is set. Assume the price list price = 6.15 and markup change = 1.52%, with the result = 6.24348

Table: Rounding Example

Prices	Profile Option: Blank (Default)	Profile Option: Enforce Price List Rounding Factor	Profile Option: Enforce Currency Precision
Round To value from Price List window (see row on right).	-2	-2	-4
List Price	6.15	6.15	6.15
Mark up	1.52 %	1.52 %	1.52 %
List Price (new)	6.24348	6.24	6.2435

For example, a rounding factor of -2 and a currency precision of -5, would display the following results:

115.24000

9.23000

100.00000

Rounding Considerations

The following description explains the different settings for the profile option QP: Price Rounding and how it affects price list rounding. Typically, this profile option value is set by your System Administrator. The following descriptions explain the the available settings for the profile option:

• Blank (Default):
• No limit is imposed on the number of places that can be entered on the price list after the decimal point.
• The value for a price list line is not rounded.
• The list price that displays will not be rounded by either Currency Precision or the Round To value.
• Static formula calculation results will not be rounded.
• The Round To value specified for the price list rounds the pricing engine results.
• Enforce Price List Rounding factor: If this option is selected, the value entered in the Round To field of the Price Lists window is used to:
• Round the value on the price list line.
• Round the pricing engine calculation results.
• Calculate the results for static formula calculations.
• Enforce Currency Precision: The currency precision setting determines how the list price displays. If the profile option has been set to Enforce Currency Precision then a Round To value cannot be entered in the Price List window.

Instead the Rounding To value defaults from the profile QP: Unit Price Precision Type (either Standard/Extended precision) for the price list currency. The decimal places that display for the list price is determined by the Currency Precision setting.

For more information on these profile options and their effect on rounding, see: Oracle Order Management Implementation Manual, Profile Options.

8. Enter the starting and ending effectivity dates of this price list in Effective Dates.

The Start Date defaults to the current date.

9. Enter default Payment Terms.

10. Enter default Freight Terms.

11. Enter a default Freight Carrier field.

12. Enter any Comments.

13. Navigate to the List Lines region.

Complete the remaining steps for each price list line that you want to create.

14. The Product Context is always Item.

15. Select Item Number, Item Category, or All-Items in Product Attribute field.

16. Depending on the value of Product Attribute, select an item number or an item category for the Product Value.

17. Select a unit of measure in UOM field.

18. Select the Primary UOM box if this price list line uom is the primary pricing unit of measure for the item.

Note: Oracle Pricing uses the primary pricing unit of measure and the Oracle Inventory unit of measure conversion information to price an order whose unit of measure does not have a price list line. For example, a price list has two price list lines for item A11111, one with unit of measure EA; the primary UOM and one for cases (CS). When the pricing engine receives an order in unit of measure CS, it accesses the unit of measure conversion tables to convert CS to EA.

19. Select Application Method.

Use the Unit Price for inventory items and either the Unit Price or Percent Price for service items

20. Enter Value and Formula as follows:
• For inventory items, enter the base list price of the item in Value.
• For service items, enter a value in the Value field. If Application Method is Unit Price, enter the base list price of the item. If Application Method is Percent Price, enter a percent of another item's price.
• Enter the name of a previously defined static formula in Static Formula.

If you enter a static formula, you must submit the concurrent program Update Formula Price's to calculate the value. The result of the calculation changes the value of Value.

21. Enter the starting and ending effectivity dates of this price list line in Start Date and End Date.

The dates should be within the start and end effectivity dates of the price list.

22. Enter a numeric value in Precedence; this is the product precedence.

When the pricing engine is trying to locate a price, it uses the lowest precedence numeric value to resolve conflicts when it selects more than one price list line from a price list.

23. Save your work

To define pricing attributes:

1. Select the Pricing Attributes button in the List Lines region.

2. Enter a Pricing Context.

3. Enter a pricing attribute in Pricing Attribute.

4. Select = or BETWEEN for Operator.

5. Enter Value From.

6. If Operator is BETWEEN, enter Value To.

7. Save your work.

Note: The pricing attributes are joined as AND conditions since they apply to one price list line.

To define secondary price lists:

1. Navigate to the Secondary Price Lists region.

2. Select a price list in Secondary Price list.

3. Save your work.

To delete price list information:

You cannot delete price lists, price list lines, or pricing attributes. To make price list or price list lines ineffective, change the effective dates. To make pricing attributes ineffective, make the price list line ineffective.

Creating a GSA Price List

GSA Price List enables you to define a GSA Price List for your GSA customers. The GSA Price List actually uses the modifiers form and uses the new price. You create a discount that adjusts the base price of the item to the GSA price.

You can set up multiple GSA price lists that are effective during the same time period.

   To create a GSA price list:

1. Navigate to the Define Modifier - Define GSA Price window.

The Define Modifier - Define GSA Price window displays.

Note: GSA Price List actually uses the Define Modifiers window to set up your GSA prices.

2. In the Main tabbed region, enter Discount List in Modifier List Type.

3. Enter the modifier list number in Number.

4. Enter modifier list name in Name.

5. Enter Currency.

Pricing applies modifiers to sales orders of the same currency.

6. Enter the start date and end date during which the GSA price list is effective.

7. Enter a description of the GSA price list in Description.

8. In the Modifiers Summary tabbed region, enter a modifier number as an identifier for the GSA price list.

The Level defaults to Line and the Modifier Type defaults to discount.

9. Enter the start date and end date of this GSA price list line.

Note: The Start and End Dates on the discount line must be between the start date and end date of the GSA price list. Pricing uses the discount line dates to determine if this line is effective.

10. Phase defaults to List Line Adjustment.

11. Incompatibility defaults to Exclusive.

12. Bucket defaults to 1.

13. Enter Item Number in Product Attribute.

14. Enter the item number in Product Attribute Value.

15. Enter Precedence.

16. Enter the item unit of measure.

The Application Method defaults to New price in the Discounts/Charges tabbed region.

17. Enter the item price in Value.

18. Save your work.

    To create GSA list qualifiers:

You can attach multiple GSA customers as qualifiers to a GSA Price List.

Note: You can only attach customers only at the list level. You cannot assign line level qualifiers.

1. Select List Qualifiers.

Refer to steps 2 through 8 if you want to qualify the GSA price.

2. Enter Grouping Number.

Note: Since Qualifier Context is Customer, make OR conditions by creating each qualifier with a different grouping number.

3. Qualifier Context defaults to Customer.

4. Qualifier Attribute defaults to Customer Name.

Precedence defaults from the item segment of the descriptive flexfield.

5. Enter Operator.

6. Enter customer name in Value From.

7. Enter start date and end date for the customer.

Note: The start and end dates of the list qualifiers must be within the start and end date of the modifier list.

8. Save your work.

Warning GSA behavior is affected if the Qualifier flexfield sequence for GSA qualifier is changed in the flexfield setup.

Copying a Price List

Use this procedure to create a new price list or add items to an existing price list.

Note: This function can be performed on effective price lists only.

    To copy a price list:

1. Navigate to the Copy Price List window.

The Copy Price List window displays.

2. Navigate to the Copy From tabbed region.

3. Select the price list you want to copy.

Currency and Description display.

Refer to steps 4 through 5 to select the items that you want added to the price list. Skip steps 4 and 5 if you want to copy all price list lines.

4. Optionally, enter a range of items to add.

Note: You cannot use wild cards when you specify the beginning and ending item numbers.

5. Select an item category and item category set to limit the items to add.When you add items from an item category, the process adds all items of the item category to the price list; it does not add the item category itself.

Note: You must enter both Item Category Set and Item Category for this criteria to be effective.

6. Select Include Discounts to instruct the process to copy discounts.

7. Select Retain Effective Dates to instruct the process to copy the effective dates of price list lines.

Note: The process does not copy the effective dates of the price list header. You specify the effective dates for the new price list.

8. Navigate to the Copy To tabbed region.

9. You can copy to a new price list or an existing price list.

Refer to steps 10 through 12, and 14 for new price lists and steps 13 through 14 for existing price lists.

10. Enter the Name of the new price list.

11. Enter the Description of the new price list.

12. Enter the Effective Dates of the new price list.

13. Select an existing price list.

The Description and Effective Dates displays.

14. Select the Submit button.

Adjusting a Price List

    To adjust a price list:

1. Navigate to the Adjust Price List window.

The Adjust Price List window displays

2. Select the price list you want to adjust. Currency and Description will default.

Refer to steps 3 through 6 to select the items that you want to adjust on a price list.

Enter a range of items to adjust.

Note: You cannot use wild cards when you specify the beginning and ending item numbers.

3. Select an item category and item category set to limit the items to adjust.When you select items from an item category, the process adjusts all items of the item category within the price list.

Note: You must enter both Item Category Set and Item Category for this criteria to be effective.

4. Enter an item status to limit the items to adjust.

5. Enter a creation date to limit the items to adjust. Pricing adjusts only the items added to the price list on that date.

6. Select Percent or Amount for Adjust By, as follows:
• Percent: The process increases or decreases value in the Price List by a percentage.

Enter the percentage in the Value field.

• Amount: The process increases or decreases value in the Price List by a fixed amount.

Enter the fixed amount in the Value field.

7. Select the Submit button. The request ID is displayed in the Request ID field.

Adding Items to a Price List

Prerequisite

You must first define a price list header.

Note: : Pricing submits a concurrent process when you add inventory items. The concurrent process only adds new items to a price list; it does not replace existing items, even if the existing items are ineffective.

    To add items to a price list:

1. Navigate to the Add Items to Price List window.

The Add Items to Price List window displays.

2. Select the price list to add items.

Perform any or all of steps 3-5 below to select the items that you want added to the price list.

3. Enter a range of items to add.

Note: You cannot use wild cards when you specify the beginning and ending item numbers.

4. Select an item category and item category set to limit the items to add.When you add items from an item category, the process adds all items of the item category to the price list; it does not add the item category itself.

Note: You us enter both Item Category Set and Item Category for this criteria to be effective.

5. Enter an item status to limit the items to add.

6. Select Set List Price Equal to Cost From check if you have Oracle Inventory installed and you want to set the list price of the inventory item equal to its cost.

Note: The list price becomes zero if you clear the List Price Equal to Cost From and the Inventory Organization does not use the standard costing method.

7. Enter Inventory Organization to indicate which organization to get the cost from if you are setting the price equal to cost.

If you do not specify an organization, the process uses the organization specified in the profile option QP: Organization ID.

8. Select the Submit button.

The request ID displays in the Request ID field.

Querying Price List Lines

When querying price list lines, use the Find Price List Lines query window to find price list lines within a specific price list. To create a new query, enter the relevant search criteria such as the product attribute context, product attribute (for example, Item Number), and product attribute value (for example, Product A), and click Find to retrieve the price list lines that match your search criteria.

To query price list lines:

1. Display the price list in the Price Lists window.

2. From a price list line in the Price Lists window, click the Find icon to display the Find Price List Lines window.

3. Enter only the criteria required for your search:
• Select a Product Attribute Context such as Item.
• Enter a Product Attribute for the Context such as Item Number.
• Enter a Product Attribute Value such as a specific Item Number.

4. Click Find to display the results of your query.

Note: To clear existing search criteria, click Clear in the Find Price List Lines window.