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 that define item and/or item category prices. Basic information includes the price list name, effective dates, currency, pricing controls, and shipping defaults such as freight terms and freight carrier. For a price list, you can define price breaks, pricing attributes, qualifiers, and secondary price lists.
A Price list is useful for maintaining the prices and other pricing details of products and services.

  • It serves as a repository of items with their related pricing details. You can call up a price list and add/edit/delete related items and item categories.
  • You can also use the price list to define attributes for the products, which will then determine the pricing action.
  • The pricing engine requires that all items, services, models, option class and options should be selected and displayed on price list.
  • Fields such as payment terms, freight terms and freight carrier are available on the price list form. By defining the OM defaulting rules to use these fields from the price list window, you are able to default values directly into the SO based upon which price list has been selected for the order.

Price List Form Details

The price list Name should be unique across PTEs (Pricing Transaction Entities) otherwise an error occurs. For example, if a price list named Corporate is created in the Order Management PTE, an error message displays if you create a Corporate price list in the Purchasing PTE.

Price List Currency
For 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.
Multi-Currency Conversion Lists
For pricing in different currencies, multi-currency conversion lists enable you to maintain a single price list for multiple currencies. However, this is an Oracle Advanced Pricing feature which is available only if Oracle Advanced Pricing is fully installed and multi-currency lists are enabled.

Round To 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. If you enter a negative number, you increase the number of characters to the right of the decimal point. If you enter a positive number, you affect more columns to the left of the decimal point. If you enter zero, rounding occurs to whole decimals. Rounding factor -3 indicates rounding to the nearest thousands (for example,.1007 rounds to .101). Rounding factor of +2 indicates rounding to the nearest hundred; for example 107 rounds to 100).
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.

Secondary Price List
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.

  1. You can assign the same secondary price list to multiple price lists but you can not assign a secondary price list to a secondary price list.
  2. If the item that you are ordering 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).
  3. Line-level discounts and modifiers that apply to the primary price list do not apply to the secondary price list.
  4. 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.
  5. 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 List: 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)

Note: If you are unable to query or update the price list after  saving or exiting from the window, consult with your Pricing Administrator for access privileges. Your security access privilege may not allow you to access the price list windows.

Other Tab


The Other tab displays the following information, and if applicable, details about the related Sales Agreement:

• List Source Document Number: The number of the sales agreement associated with the price list.
• List Source Code: Displays the code for the price list source (BSO will be the source code for sales agreement).
• Pricing Transaction Entity: Displays the name of the pricing transaction entity creating the price list. This field cannot be updated.
• Source System Code: Displays the code name for the source system creating the price list such as QP for pricing. This field cannot be updated.
Note: The Pricing Transaction Entity and Source System fields display for all price lists regardless of whether there is a related Sales Agreement.
• Shareable box: Indicates if the modifier is shared or not. If non-shareable (the default), then this modifier is specific to that agreement and cannot be used with other sales agreements.

If shared, the modifier is not exclusive to the sales agreement and can be selected for use with other agreements. Source Document Number: This is the Number of the sales agreement associated with the price list. Once you have completed entries in the price list header, you can add price list lines that define the actual items and list prices for the price list.


Enter the price list line details as given below

You can define the following types of prices for price list lines:

  • 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 displays an example of a price break setup:

1.  Product context is always item.
2.  Depending on the value of Product Attribute, select an item number or an item category for the Product Value.
3.  Select a UOM (unit of measure).
Select Primary UOM if this price list line UOM is the primary pricing unit of measure for the item. 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.
Select an Application Method. Use Unit Price for inventory items and either the Unit Price or Percent Price for service items
4. 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.
5. 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.
6. Enter a numeric value in Precedence; this is the product precedence. When the pricing engine is trying to locate a price, it uses precedence to resolve conflicts when it selects more than one price list line from a price list.
7. Save your work

Copying a Price List

You can quickly create a new price list by copying an existing price list. Only active price list lines (those with an effective end date later than the current date) can be copied.

Adjusting a Price List
Use this process to adjust the prices for a price list. You can adjust prices for the entire price list or selected items, item category sets, and item categories. You can define your criteria further by selecting the item status or creation date of the items to adjust.
For example, you can specify a category so that only the price list lines for the selected category are adjusted. If you leave any of the fields blank, pricing adjusts the price list regardless of that field. You can adjust the price by either an amount or percent:
■ Percent: Enter a value to adjust list prices by a certain percentage. For example, when adjusting by a percentage, entering 10 raises list prices by 10 percent while -10 lowers list prices by 10 percent.
■ Amount: Enter a value to adjust list prices by a fixed amount. For example, when adjusting by an amount, entering 5 increases list prices by five whole units of currency. Entering -5 decreases list prices by five whole units of currency.

Note: You can only view or update a price list for 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.

Oracle Applications Fusion Cloud - Inventory

Oracle Cloud/Fusion Manufacturing Cloud training will help you develop the fundamental skills required to set up and use the Manufacturing module. This training covers all the tasks, setups, forms and reports used in Manufacturing and related modules