- OracleApps Epicenter - http://www.oracleappshub.com -

Oracle Pricing Module – A Note

It provides an advanced, highly flexible pricing engine that executes pricing calculations for Oracle Order Management. Some of the features which Pricing allows you are:

Concepts in pricing

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 like price list name, effective dates, currency, pricing controls,rounding factor,shipping defaults such as freight terms and freight carrier,and one or more pricing lines, pricing attributes.

Pricing Formulas
Formulas are mathematical expressions that the pricing engine uses to determine the list prices of items and the discounts that apply to those items.

Price List Qualifiers/Modifiers

Price List Qualifiers/Modifiers Modifiers enable you to setup price adjustments (for example, discounts and surcharges) and freight and special charges (modifier lists) that the pricing engine applies immediately to pricing requests.Using modifiers you can:

Pricing Attributes

Pricing attributes are characteristics of products and services that specify when the characteristics help to determine the price of a product or service. Distance, age of a related product, customer class, product family group, and level of service are examples of pricing attributes. You can specify one or a combination of pricing attributes and assign them to a product. At order entry time, the pricing engine evaluates the attributes you have specified during formula setup to calculate the price.

Steps for pricing an order

11 Comments (Open | Close)

11 Comments To "Oracle Pricing Module – A Note"

#1 Comment By NRIAJ On September 26, 2007 @ 6:15 am

Want the code for this oracle pricing

#2 Comment By hi On March 31, 2008 @ 11:47 pm

need oracle pricing API which calculates adjusted amount

#3 Comment By Sanjit Anand On April 1, 2008 @ 1:59 am

could you elaborate with more details, as I am not able to understand your requirement

#4 Comment By Rafee On May 2, 2008 @ 12:01 am

hi anand,
My requirement is like this…
In quick sales order form in order lines order item is A,quantity 10 (if list price of A is 10$)(if discount modidfier with the application method Amount 2$ is ) oracle pricing engine will calculate unit selling price by applying modifier 8$ and inserts the adjustments to oe_price_adjustments table.Its a seeded functionality..
question 1)
how to do the same manually by using API by passing so
My requirement without doing this i want to populate unit seeling price,adjusted values..(like adjusted amount …application method modifier which is applied…) manulaly by passing SOME PARAMETERS to an API which returns the without using sales order.
Unit Price Before an Order Creation and Quote , from the API of ” QP_PREQ_PUB.PRICE_REQUEST ” ,. based on Item ID , Quantity and two Modifiesrs(Price List ID and Order Type ID).

#5 Comment By rafee On May 11, 2008 @ 9:33 pm

when can i expect reply from you..

#6 Comment By Bala On May 14, 2008 @ 11:03 pm

Want the code for this oracle pricing

#7 Comment By rafee On May 19, 2008 @ 7:11 am

hi Bala,
do u have the code..for my requirement. please give me the code..thanks in advance

#8 Comment By Imran khan On July 22, 2008 @ 11:52 pm

Hi Anand,

Can you plz elaborate more on Advance Pricing setups.

For example;
How to use Modifiers and Qualifiers for a given price list with a simple example.

Apprecita ur help,

Thx N Regs,

#9 Comment By ranjith On December 8, 2008 @ 8:08 am

Hey bala,
Can u pls give me the code for this oracle pricing.

#10 Comment By Lorena On October 24, 2009 @ 8:44 am

Hi, i have a problem with setting up a Minimum price list.
I need to create a price lists that have the next result:

If a customer buys for $100, the price in sales orders must be $150.
If it buys for $149, the price must be $150.
But if he buys for $200, the price must be $200.

I need to set de price list called “MINIMUN USD 150”.

please i need help urgent!

#11 Comment By Suhas On June 16, 2011 @ 6:56 am

Thank you Sanjit…This is very vey halpful