A day in the life of an Oracle Applications Consultant

Oracle Advanced Pricing Module

This post contains details of a new author who has joined OracleAppsBlog and will be blogging under the Advanced Pricing Category

Suvabrata Biswas, an Oracle Applications Consultant who runs a consulting company based out of Houston Texas, is joining OracleAppsBlog and will be blogging under the Advanced Pricing Category. This category didn’t exist before so I have added it.

Suv has broad functional experience in Advanced Pricing, Bills of Materials, Assemble to Order, Quality, Engineering, Inventory, Work in Process, Procurement, Cost Management, Enterprise Asset Management, Order Management, Planning and MultiOrg. He also has broad technical experience with Oracle Application’s technical architecture, Oracle tools and operating systems such as Unix and NT. You should also check out his companies site. You can read Suv’s membership profile here or if you’re a member you can e-mail Suv via the profile e-mail console.

Welcome to OracleAppsBlog and we look forward to your contributions grin

Posted by Richard Byrom on 06/25 at 06:26 PM
  1. cool smile
    I am currently working on a project implementing Advanced Pricing with Service contracts. There are specific requirements from the client. I am looking for a way to set up advanced pricing which will look at an amount first and use that amount to calculate a price based on a factor and then divided by 12 (months). Let me know if someone has been involved with such an implementation already.

    Posted by .(JavaScript must be enabled to view this email address)  on  11/20  at  03:44 AM
  2. This would involve creating a pricing attribute and Formula. you would map the pricing attribute to point to the amount you are referring and then use this pricing attribute in a formula. You will also need a factor list as one of the step in the formula to decode the value of the pricing attribute (“amount”) to a factor. This step value will be devided by 12 in the formula expression to give the final price.

    Posted by .(JavaScript must be enabled to view this email address)  on  11/26  at  05:38 PM
  3. Hi Suv
    I recently started working in Oracle apps . The group i am working most works on Service Sales data which involved Service Conracts related data , ie OKC n stuff .
    I have already got some familiarity with IB n SA tables n structures .However , part of my assignment now involved looking into Pricing Module i with respect to products associated with Contracts . This would ultimately lead to finding total list price on the contract which would later be used for Sales perdiction n other purposes by business .

    I was wondering if you tell me
    1. Whts the pre-requisite functional area which i should know in order to understand pricing better ??
    2. Although information here is excellent , but at this point it just seems too much n too indepth for me , could u suggest good links or doc’s i should read to get familiar with Pricing ??

    please let me know
    I guess i am starting off with Apps in Service Agreements n IB area, so tryin to figure out which is best way to understand all this better n grow in knowledge

    Posted by .(JavaScript must be enabled to view this email address)  on  04/25  at  01:59 PM
  4. I was wondering if anyone has found a way to apply more than one cost to a single item in Oracle. For example we may have several end users who have negotiated a deviated cost with one of our suppliers. The item may normally cost us $100.00 but if we sell it to customer A our cost is $95.00 if we sell it to customer B our cost is $92.00. Can multiple cost be associated with an item in Oracle or is their a 3rd party software company that can work with Oracle to handle contract deviated costing?

    Posted by .(JavaScript must be enabled to view this email address)  on  02/08  at  01:42 AM
  5. Is there any way to make a pricing modifier kick off from another pricing modifier? We are doing mix and match pricing. If 5 items from a group of different items is placed on order we want to give promo prices for selected items. One modifier would see if order qualifies for mix and match and trigger a modifer to override prices. Is this available with seeded fuctionality?

    Thanks in advance,
    Nancy Hoye

    Posted by .(JavaScript must be enabled to view this email address)  on  02/01  at  04:28 AM
  6. Hi Nancy

    I would suggest you also post this question on the forum. I’ve noticed that the e-mail to Suv of comments to this post bounced so your question would become more visible to a wider audience in the forum.

    Posted by Richard Byrom  on  02/01  at  12:23 PM
  7. Thanks for the response Richard. I had also posted question to forum. If I get resolution I will post it here.


    Posted by .(JavaScript must be enabled to view this email address)  on  02/01  at  07:26 PM
  8. Hi,

    Does anybody know how to set-up a modifier that will apply a discount at the subtotal level (Order level0 after all other modifiers have been applied?  We have Discount Modifiers in place and want to build a modifier that will attach an additional discount but based o nthe discounted price and not on the List price so to speak.


    Posted by Riverananda  on  08/20  at  04:47 AM
  9. Oracle Advanced Pricing provides the flexibility to meet the needs of complex pricing situations for a range of industry business requirements including: 70-630 consumer goods, telecommunications, services, high technology, automotive, and aerospace/defense businesses that sell to other businesses; and, telemarketing, mail order catalog, and web store businesses that sell directly to consumers. 000-973 Learn To:

      Define pricing rules and price products or components at any level in either customer or product-based hierarchies
      Use multiple currency price lists that enable global pricing
      Create modifiers to set up price adjustments (for example, discounts and surcharges), benefits (for example, free goods, coupons) and freight and special charges
      Generate price books that list all orderable products and their prices
      Set up and use price lists with pricing lines to define item and/or item category prices 640-460

    Posted by .(JavaScript must be enabled to view this email address)  on  06/22  at  08:32 PM
  10. pricing Modifiers - Setting “Usage” Limits.
    I need to set-up a modifier that will grant 25% off on all order lines for one time only per customer (first online order only).  I am able to set-up the line limits at Usage = 1, constraint = customer name.  But it works only for the first line of the order.  Subsequenbt lines do not get the midifer applied.

    This is a modifier type = Discount List.  For level I have tried, Line, Group of Lines and order but order won’t allow me to enter exclusions (I have 10 poducts that need to be excluded). The modifier type is discount and the Product Attribute is ALL ITEMS

    Posted by Riverananda  on  07/03  at  06:42 AM
  11. This is hopefully a simpler way to pose the question.  I am doing thsi modifier at the “Order” Level for ALL items = 25% off List price.  However, the Line and/or List Limit is not letting me establishc a limit Usage = 1, Constraint = Customer Name.  it is telling me “Constraint Customer/Product not allowed for thsi Header/Line Limit”

    Posted by Riverananda  on  07/03  at  07:37 AM

Add Comment Information Here

Please note that comments will only be accepted from valid members of this site who provide feedback that is beneficial to readers of the blog. ALL comments (even those from members) will be subject to moderation.


Notify me of follow-up comments?

Submit the word you see below: