My Oracle Support Banner

Wrong Sequential Discount Applied In Case Of In-advance Charge (Doc ID 2409111.1)

Last updated on JUNE 26, 2018

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.15.0 and later
Information in this document applies to any platform.

Symptoms

On : 7.5.0.15.0 version, Pipeline Manager

ACTUAL BEHAVIOR
---------------
In case of in-advance cycle fee, sequential discount is not applied correctly.

Consider the below scenario with bill in-advance 3 months. 

There are 2 sequential discounts: fixed discount (credit amount $100) with higher priority, and a full 100% discount. Monthly cycle product charge of $599 with 3 months in-advance.
For in-advance billing, 2 cycle events were generated 
1. Feb 6 - Mar 1 for the first month 
2. Mar 1 - Jun 1 for the in-advance period 

Enabled prorated fixed discount in realtime pipeline, this is how discounts apply:   
For event 1 - 1 cycle_forward (Feb 6 - Mar 1) created, prorated scale (Feb 6 - Mar 1), discounts applied -82.14, -409.9  => 492.04 
For event 2 - 1 cycle_forward (Mar 1 - Jun 1) created, prorated scale (Mar 6 - Jun 1), discount applied -283.7. No prorated percent discount for the period (Mar 1 - Mar 6).

EXPECTED BEHAVIOR
-----------------------
Expect 3 month in-advance total charge after discount: $1415.64
Reverse $300 fixed discount that was created for in-advance period (Mar 1 - Jun 1)
-$16.3 (prorated period 1 mar - 6 mar)
-$81.36 (prorated period 1 mar - 6 mar)
-$283.7 (prorated period 7 mar - 31 may)
-----------------------------------------------------------------
-$381.36 (Total sequential discount)


STEPS
-----------------------
The issue can be reproduced with the following steps:
1. Enable <SequentialCycleDiscounting> in the /config/business_params object 
2. Create 2 discounts: a percent discount, and a fixed discount. Create product with 3 month in-advance.
3. Create account (Feb 1), and purchase above plan a couple of days later (Feb 6), set the cycle dates for the discounts in the future like 6 months (Aug 1). 
4. Changed cycle date of fixed discount to current date (Feb 6).
5. Changed cycle date of percent discount to current date (Feb 6).


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, discount is not applying correctly.

Cause

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.