How Can One "Round Down" the Calculated Discount Amount by Capturing the SubTotal at the End of Pricing Bucket10 in a Custom Pricing Attribute That Can Then Be Rounded As Such n a Formula?
Last updated on MAY 22, 2018
Applies to:
Oracle Advanced Pricing  Version 11.5.10 and laterInformation in this document applies to any platform.
Goal
How we can always round down the calculated discount amount by capturing the sub total at the end of pricing bucket10 in a custom pricing attribute that can be rounded as such in a formula?
Using the current functionality, we are not able to achieve the desired result. As an example consider the following scenario:
List Price: 1625
Discount: Promo PA : 350 : Amount Based Discount.  Pricing Bucket 10
Net Price after Bucket 10: 1625350: 1275
Discount: Draft : 1%  Pricing Bucket 20
i.e. : 1275 *0.01 = 12.75 > This should be rounded DOWN to 12.00
Net Price after Bucket20 is 1275  12 : 1263
Discount: Brand Discount: 14%  Pricing Bucket 30
Discount: Truck Allowance : 3%  Pricing Bucket 30
i.e : 1263 * 0.14 = 176.82 > This should be rounded DOWN to 176.00
i.e : 1263 * 0.03 = 37.89 > This should be rounded DOWN to 37.00
Net Price after Bucket30 is 1263  176  37 = 1050.00
So the final unit selling price is 1050.00
Solution
Sign In with your My Oracle Support account 

Don't have a My Oracle Support account? Click to get started 
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms