Search 800 + Posts

Apr 17, 2010

Oracle iStore and Advance Pricing Integration

Recently I was working with my client to build a custom solution to Integrate iStore with Pricing.

Requirement was, Price in the iStore catalog should be same as that of Order Management .Not a big deal , that was what I said whey they called me , but letter I have realized that when we create Sales Order in Order Management we have all the information that we need like
1.    Customer Party Details
2.    Bill – To /Ship – To
3.    Order Type
4.    Price List
5.    Shipping Method

And based on above information, Qualifier /modifier got triggered and pricing engine derived the Price for Item. where as in iStore Catalog we don't have these attributes/fields available, more over customer has complex business requirements for pricing and for that he has lot of custom qualifiers, and these qualifiers have no issues in Order Management (as OM support all the standard and custom Pricing Qualifiers) , but using those custom qualifier in iStore is not available in out of box solution.

In iStore Catalog at the time of Catalog we have very limited Information available
1.    Customer Name and Party Name
and based on this information none of the custom qualifiers  conditions satisfied and thus there was lot of price difference in iStore Catalog and the iStore Cart (in Cart price was same as  Order Management where as in case of Catalog it was different).

To fulfill this requirement, we quickly designed one UI where custom enter all the attributes ( like the above 5) , and then I developed an custom process to read the values from custom UI and search through the qualifer in advance pricing and get the qualifiers and feed that to QP_PREQ_PUB.PRICE_REQUEST , and as expected value return by the API was same as price return by the Order management.

In face we latter scrap the custom UI and used the lookup code to capture all the  attributes on which customer has build the qualifiers.

That’s all for now.


  1. Hi ,

    We have a requirement to set the Freight charges based on the shipping method selected.We can achieve this condition in OM through Qualifier setup.As qualifiers are not supported by Istore .what customization can be done to make the freight charges calculated based on the shipping meathods selected at Istore level

  2. You can achive this via attribute Mapping.

  3. Hi..I have created custom API and mapped attributes .. but discount in istore get Applied intermittently...

  4. Need help on below requirement for Oracle iStore. Can this be integrated through Oracle Advance Pricing, If yes how and also please let me know how can we link questionnaires to Pricing?
    Can you please help on solution approach for this and all are inter-linked.

    1)Ability to save partial quote. Admin team should be able to view the quote (partial saved as well) and be able to edit it.

    2) Customer should be able to save questionnaire half way through the process. Saved questionnaire can be edited and submitted later.
    Admin should be able to access saved questionnaire and complete the same.

    3) Promo codes (assume that there will be multiple promo codes (few examples given below)
    - Number of free relocations
    - % discount of overall cost
    - Free up to "X" number of miles
    Solution approach for contracted pricing based on assumption that promo codes would need to be set up and applied automatically.