Price lists are essential to ordering products because each item entered on an order must have a price. Price lists, like modifiers, consist of a header region that defines general information such as effective dates and currency, and price list lines that define item and/or item category prices. For price list lines, you can define price breaks, pricing attributes, and qualifiers.

Using Price Lists in the HTML User Interface

Oracle Advanced Pricing provides an HTML-based user interface (UI) that features guided steps, user-friendly pages, and shortcut links for setting up and maintaining modifiers, price lists, and qualifiers.

You can use this HTML format for many tasks that were previously available only using the Oracle Forms-based interface. Tasks that can be completed in HTML are identified by (HTML Interface) in the task title, for example, Creating a Price List (HTML Interface).

Price List Terms

The following defines common price list terms that you will see when setting up and maintaining price lists:

• Effective Dates: Use starting and ending dates to prepare price lists ahead of when they are valid and to ensure they are not used until their start dates.

  Attention: You cannot create a future-dated price list that has the same name as an existing price list. For example, suppose you have a price list named Price List A, with effective dates 01-Jan-2006 to 31-Dec-2006, and you want to create a second price list named Price List A, effective 01-Jan-2007 to 31-Dec-2007. The system will not allow you to create the second price list because a price list with the same name already exists.

• Inactive Price Lists: You can temporarily or permanently inactivate a price list by deselecting the Active check box. For inactive price lists, you can still complete the following actions:

  • Query the inactive price list.

  • 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.

• Currency: If you have global customers or do pricing in different currencies, the multi-currency feature enables you to maintain a single price list for multiple currencies. For more information on multi-currency price lists, see Overview of Multicurrency Conversion Lists.

• Round To: The Round To value defines 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 positive number such as 2 indicates the number of places to the left of the decimal point. For example, a round to factor of 2 indicates rounding to the nearest hundreds so 107 rounds to 100.

  • A negative number such as -3 indicates number of places to the right of the decimal point. For example, a round to factor of -3 indicates rounding to the nearest thousands so 1.1445 rounds to 1.145.

  The pricing engine rounds the base price and all discount amounts before using them in calculations.

  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. The value returned depends on the value that was set for the profile option QP: Unit Price Precision Type:

  • Standard: The rounding factor defaults to the currency's precision value. You can override the rounding factor to any value greater than or equal to the currency's precision value.

  • Extended: The rounding factor defaults to the currency's extended precision value. You can override the rounding factor to any value greater than or equal to the currency's extended precision value.

    Note: If multicurrency is enabled, the Round To field will be disabled and will reflect the Round To value defined for the Multi-Currency Conversion window.

  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 Guide, Profile Options.

• 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.

  Note: You can only add a secondary price list one you enter the currency for the primary price list. This ensures that the secondary price list has the same currency as the primary price list.

  If the item you are ordering is not in the primary price list, the pricing engine looks for the price on any attached secondary price list. If the item is found, the pricing engine uses the highest precedence secondary price list (the secondary price list with the lowest value in the precedence field).

  If an item appears in 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.

  Note: The pricing engine does not evaluate qualifiers on secondary price lists; however, some user setups may require them to be evaluated. In these cases, the System Administrator must change the profile QP: Qualify Secondary Price Lists to Yes. See Oracle Advanced Pricing Implementation Guide, Profile Options for more information.

• 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 Sources