My Oracle Support Banner

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? (Doc ID 2401968.1)

Last updated on MAY 22, 2018

Applies to:

Oracle Advanced Pricing - Version 11.5.10 and later
Information 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: 1625-350: 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

To view full details, 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 a vibrant support community of peers and Oracle experts.