How To Achieve The Proration For A Discount With Fixed Amount (Doc ID 798055.1)

Last updated on APRIL 03, 2023

Applies to:

Goal

How to accomplish the Proration for a discount with Fixed Amount ?

Consider the following scenario:

1) Create a product with Monthly Cycle Forward (MCF) event that charges $100
2) Create a discount that gives the fixed amount discount as $20 on that MCF.
     The discount is configured as below:
          Drum Exp : TOTALQ
          Rule Type : Tiered
          Drum Type : Quantity
          Base Expression : TOTALC
          Amount : -20
3) Associate these two product/discount to one deal
4) Create a customer with this deal on 1st May
5) Now the balance amount for this account will be $80 (i.e. $100 - $20)
6) Move the pin_virtual_time (PVT) to 15th May
7) Cancel the discount through Customer Center
8) Now the the $20 will be reverted back and the balance amount for that account will be $100, where as the expected is the discount should be prorated and the amount should be $90.

How can the above requirement be achieved?

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.