% Based Adjustment Calculated Incorrectly In Last PCPE When Ex-gratia Is Applied To The Invoice (Doc ID 2930829.1)

Last updated on MARCH 23, 2023

Applies to:

Symptoms

% based adjustment calculated incorrectly in last PCPE when ex-gratia is applied to the invoice


- Ex-gratia is a function based adjustment which return amount * -1
- Sequence of the % based adjustment is after ex-gratia adjustment

Scenario 1:
Ex-gratia period spanning one PCPE and has a % based on adjustment works fine i.e., DPT moves to end of ex-gratia period when a 0$ registration is applied

Scenario 2:
Ex-gratia period spanning one PCPE and has no % based on adjustment works fine i.e., DPT moves to end of ex-gratia period when a 0$ registration is applied

Scenario 3:
Ex-gratia period spanning more than one PCPE and has no % based on adjustment works fine i.e., DPT moves to end of ex-gratia period when a 0$ registration is applied

Scenario 4:
Ex-gratia period spanning more than one PCPE and has a % based on adjustment - DOES NOT work i.e., DPT moves to end of first PCPE when a 0$ registration is applied.

Steps to reproduce:
- Create a monthly DD policy with start date of 24-NOV-22
- Run example calculation with input date 24-NOV-22 (result amount = 0$)
- Edit policy
- Add ex-gratia period from 24-NOV-22 to 23-DEC-23
- Run example calculation with input date 24-NOV-22 (result amount < 0$)

Result amount of the percentage based discount should be $0 as ex-gratia as negated the base premium completely in both the PCPEs. Refer to attachment for details.

The should work for back dated, future dated ex-gratia periods and also the ex-gratia period can be part invoice periods or multiple invoice periods as well

Actual result:
- Calculation results of PCPE 1 has base premium, ex-gratia (- of base premium), %

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.