Recalculation Done Due To Sequential Discounts Incorrect (Doc ID 1477414.1)

Last updated on FEBRUARY 14, 2019

Applies to:

Symptoms

The user has two account-level discounts that can be purchased, both marked as sequential. One is a flat 35% discount on currency, and the other affects other resources (not currency). The percentage is different depending on the resource.

Consider this scenario:
0. Set sequential discounting on, accounting cycle customized to short cycle.
1. Create a CF (Cycle Forward) product P1 for $5,
               a sequential discount D1 of 35% that acts on currency,
               another sequential discount D2 that acts on non-currency.
2. On Sep4, create an account with Billing Day of Month(DOM) as 6, so next billing is Sep 6.
3. On Sep4, purchase the deal containing product P1 and sequential discount D1.
    Balance Impact from P1 = 2/31 x 5 = $0.32
    Balance Impact from D1 = - 0.35 x $0.32 = -$0.11
    Bill In Progress of $0.32 - $0.11 = $0.21
4. On Sep4, purchase D2.
    No change in Bill In Progress since D2 has no impact on currency.
    Still, 2 CF events generated because of sequential discounting with Balance Impacts of +$0.11 and -$0.11
5. On Sep5, cancel D2.

Expected result : There should be no change in Bill In Progress since D2 has no impact on currency.  
                         Bill In Progress of $0.21

Actual result     : 2 CF events generated, one with Balance Impact of +$0.11 and the other with -$0.12, thus there is a net Balance Impact of -$0.01.
                         Bill In Progress becomes -$0.20

Changes

Cause

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