Oracle EBS Learnings

This post describes how to use the attribute mapping method in Oracle Advanced Pricing to implement a complex contract pricing rule Recently I came across the following pricing requirement that seemed to be tricky at first glance: - Use price breaks based on a weight of an item as defined in a DFF.  An item from Inventory is assigned to a contract line and has a quantity of 1 with a UOM of Each Each item has a break price (either by item category or the item number) based on the weight. E.g., price is $1000 < 5000 tons and $1500 if weight is between 5001 and 9999 tons and $2000 if > 10000 tons. The Advanced Pricing allows you to hook up your SQL code to drive pricing. The attribute mapping feature of  Oracle Advanced Pricing  helped us to implement the above pricing rules by adding a few lines of SQL code. First, we cannot use the standard price break functionality to achieve this since standard price break uses volume or quantity as basis. We followed the steps bel