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

Oracle Pricing API

Some time back, I had opportunity to work some conversion in oracle pricing module; Though It was pretty simple task for mine only price list and qualifier need to convert. A week back, when a friend of mine asked some information about Pricing Module, I thought to share the information, which I collected at that time. So here are the lists of Application Program Interfaces (APIs) that Oracle Pricing has. These APIs can be used in custom programs or for doing conversion or migration activity for using some of the pricing functions.

I hope this information given above will be useful in your Oracle Advanced Pricing endeavors.

6 Comments (Open | Close)

6 Comments To "Oracle Pricing API"

#1 Comment By rafee On April 30, 2008 @ 5:52 am

hi anand,
Do you have any wraper program which will use
My Requirement is Without using sales order i want to populate unit selling price,Adjust ments applied on the item.
Let take one Example…
ITEM A:List Price 10$
Modifier 1$ (Discount/Application method is Amount)
By passing inventory item id,order_type_id,price_list_id,ordered_quantity..etc…
It should return unit selling price,Applied modifier,adjusted amount,phase,bucket…etc…can you help me….

#2 Comment By Sanjit Anand On April 30, 2008 @ 11:00 pm

hey i donot have any code at this time, i will try to see in my old folder.

Meanwhile try to see in irep.oracle.com

#3 Comment By Rafee On May 30, 2008 @ 3:06 am

Anand can u please respond quickly

#4 Comment By sumanth On October 14, 2008 @ 10:20 pm


I have walked through the site. It is informative.

I am looking for indetail of Qualifier API. could you please help in this regrad.

I have searched oracle meta link…could not find any document as TCA API. which refers indetail.

It would be helpful if you provide me document for qualifier in detail


#5 Comment By Bhaskar Akkala On February 11, 2009 @ 10:42 am

Can you please let us know how to use QP_PREQ_GRP.Price_Request api for end-dated products. That API will not return the list price if the product is end dated but would like to know even for end dated products list price. please suggest.

#6 Comment By Raghavendra Prasad On February 23, 2009 @ 6:17 am

Hi all,

I have walked through this site , very useful site for information getting .

I am Looking Complete indetails of Qualifier API, With Example.

I have serached in all sights reagdring for Qualifiers API.

If any body have it is very help full to me .

At least Small Example Code is also enough to me .

Advance Thanks

With Regards