Invalid Prorate After Purchasing a Discount when Two More Discounts Are Active in a Given Cycle (Doc ID 2167577.1)

Last updated on SEPTEMBER 20, 2023

Applies to:

Goal

On :  7.5.0.14.0 version, Subscription Management

Scenario:
Product P1 is fully discounted (-100%) by two consecutive but not overlaying instances of D_PROM_VIDPACK08.
Therefore, there are no balance impacts on this product.
Because there are two consecutive discounts, there is a point where one ends, and another one starts.
Thus, there is also a billing cycle when there are two similar discounts active.
Between two phases of this billing, purchased another -100% discounts (D_DUNN_VIDEO_W2, D_DUNN_VIDEO_W2_PR) in a previous billing time span.
There should be no balance impacts at all. Unfortunately, there is a 1 day prorate (1,54) charged for the product.

Steps to reproduce:
Set PVT = 01.12.2015
1. Create Account, billing day = 19.
2. Create service
3. Purchase product P1: start_t = 01.12.2015 (current time), end_t = infinite (null). FLIST1
4. Purchase discount D_PROM_VIDPACK08 instance 1: start_t = 01.12.2015 (current time), end_t = 01.02.2016. FLIST2
5. Purchase discount D_PROM_VIDPACK08 instance 2: start_t = 01.02.2016 (end_t of instance 1), end_t = 01.02.2017 (1 year length). FLIST3
6. Set PVT = 19.12.2015
7. Initial billing, phase 1.
8. Between billing cycles:
   a) Purchase discount D_DUNN_VIDEO_W2 instance 2: start_t = 19.01.2016 (next_bill_t), end_t = infinite (null). FLIST4
   b) Purchase discount D_DUNN_VIDEO_W2_PR instance 2: start_t = 19.01.2016 (next_bill_t), end_t = infinite (null). FLIST4
9. Set PVT = 20.12.2015
10. Initial billing, phase 2. Invoicing
11.Set PVT = 19.01.2016
12. Next billing, phase 1
13. Between billing cycles:
   a) Purchase discount D_DUNN_VIDEO_W2 instance 1: start_t = 19.12.2015 (last_bill_t), end_t = 19.01.2016 (current time). FLIST5
   b) Purchase discount D_DUNN_VIDEO_W2_PR instance 1: start_t = 19.12.2015 (last_bill_t), end_t = 19.01.2016 (current time). FLIST5
14. Set PVT = 20.01.2016
15. Next billing, phase 2.

Query:How to over come this scenario

Solution

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