Incorrect Billable Charge Amount after Removing Suspension (Doc ID 3071027.1)

Last updated on FEBRUARY 10, 2025

Applies to:

Symptoms

On : 5.1.0.0.0 version, Individual membership

ACTUAL BEHAVIOR
--------------- 

Individual On Suspension
Incorrect Billable Charge amount for individual , will have to hold billing for all individual on suspension.

This is a custom scenario where customer marked some premium timelines for suspension. Hence, the calculated premium amount for such timeline is 0$.
Once the suspension ends, application should recalculate the correct amount. However, currently, application doubling the premium amount.



EXPECTED BEHAVIOR
-----------------------
Expected Billable charge should be created with amount as in CI_PRCE_CALC.calc_amt

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Step 1 Membership 6/1/2024 – 5/31/2025, pricing Rule Exist with Start Date 6/1/2024 and End Date 12/31/9999
Rate Guarantee Exist 1/1/2024 – 12/31/2024
Billable Charge created from 6/1/2024 - 5/31/2025 for base rate , loyalty discount, EFT discount

Step 2 Suspension on Individual membership from 12/1/2024 to 12/31/2100 [ Open Ended].
Custom Batch process updates calc_amt = 0 in CI_PRCE_CALC table for suspension period.
Billable charge created for suspension period as zero dollar from 12/1/2024 to 5/31/2025

Step3 : Suspension End Date is updated to 12/31/2024
Suspension on Individual membership from 12/1/2024 to 12/31/2024 [ Suspension for one month]
Custom Batch process updates calc_amt = 0 in CI_PRCE_CALC table for 12/1/2024 to 12/31/2024.
Billable Charge for suspension coverage period 12/1/2024 exist

Step4 : Suspension End Date is removed .
Membership is repriced from 12/1/2024 the day suspension was removed.
Custom Batch process updates calc_amt for discount for running total in CI_PRCE_CALC table.
Billable Charge recreated for membership period but amount shown is double actual pricing rate amount. Billable Charge sq details amount is incorrect however CI_PRCE_CALC amount is correct

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot caculate Billable charge correctly.

Cause

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