Advanced Pricing

Pricing Security

In addition to the functional security, Oracle Advanced Pricing provides an additional level of security called pricing security. Pricing security provides an additional security which can be used to restrict pricing activities such as updating and viewing pricing entities to users who are granted specific access privileges.


QP_PREQ_PUB.PRICE_REQUEST API can be called to obtain the Price of an item

NB - is important to ensure that the pricing phase on the modifier line matches the pricing event used when calling the API.

Adjustment Method

The adjustment method (also known as the application method in the forms-based UI) determines how the modifier applies the price adjustment. You can select from the following adjustment methods:

Percent: Creates a percentage price adjustment on each unit based on the percentage entered in the Value field. For example, to apply a 10 percent discount, select percent as the adjustment method.

Modifier Concepts

Using modifiers, you can set up price adjustments, benefits, freight and special charges, and promotional limits to control spending or usage. You can define simple discounts and surcharges as well as more advanced deals and promotions. The following list describes the main modifier concepts and related entities:


Modifiers enable you to set up price adjustments (for example, discounts and surcharges), benefits (for example, free goods and coupons), and freight and special charges that can be applied immediately to pricing requests or accrued for later disbursement. Using modifiers, you can:

    * Set up a modifier list with multiple modifier lines that define the terms of the price adjustment.

Price Breaks with Block Pricing

Using block pricing, you can apply a lumpsum price rather than a per unit price to a price list line. Block pricing also provides flexibility when the unit of measure (UOM) of the header is different from the pricing attributes of each break range.

In non-block pricing price breaks, the UOM of the break range lines is the same as that of the header.

Price Breaks

You can use price breaks (bracket pricing) to define prices that vary with the quantity ordered. For example, if you buy up to 10 items the price is $20 per item, but if you buy more that 10 items, you get a lower price per unit. Note: If you define a price for an Item Category, then all items within the category are eligible for the price break.

When setting up price breaks, you can define price breaks as either Point or Range breaks:

Secondary Price List & Qualifiers

1. In the Secondary Price List tab, select a Secondary Price List. Advanced Pricing - Price Lists window 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).

2. Save your work.

Attribute Management

Attribute mapping enables you to extend your pricing capabilities by using data from a wide variety of non-standard sources to drive your pricing actions. The data sources for the qualifiers and pricing attributes can be from within or outside of Oracle Applications.

Using the attribute management feature, you can complete the following tasks: • Create new contexts and attributes • Update existing contexts and attribute properties • Disable existing attributes.


The following image depicts the setup flow for Oracle Advanced Pricing. Some of the steps outlined are required and some are optional. If you have already completed a common-application setup (setting up multiple Oracle Applications products) some of the following steps may be unnecessary.

All Rights Reserved. Copyright 2008-11