Issue With Proration On Change Rate Plan (Doc ID 1166006.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.1 to 7.3.1.0.1 [Release 7.3.1]
Linux x86-64

Symptoms

Change Rate Plan gets errorred out  with error of PIN_ERR_CREDIT_LIMIT_EXCEEDED.

When we perform a change rate plan a forced pro ration is expected. Below business scenario can be considered:
There are currently 2 plan $50 and $70 for plan transition is possible.Also a zero dollar credit limit is set for new customers.$70 has 3 services (Voice,SMS and Data) and $50 has 2 services(Voice and SMS). Below is the example of issue:
A customer is created with $70 plan and he has a current balance of $0.
After one day of service customer wants to transition the plan to $50.
We expect the customer to be prorated that is charged one day and $50 plan remaining amount credited back to customer.
In this we expect the plan change to be successful and $17 credited back to the customer.
But instead of that the plan change fails with an error of PIN_ERR_CREDIT_LIMIT_EXCEEDED.


After analyzing it looks like that the customer has $0 balance and the pro ration is service wise. Hence when his first service is prorated suppose voice the prorated to be credited with $36.99 but the cost of voice service is $39.65 and due the credit limit as zero this fails on the first step itself. However if we change the credit limit to unlimited or we make a payment to the customer this is successful


-- Steps to Reproduce:
Perform a change rate plan of customer where he is expecting credit and the current balance is 0.

-- Workaround:
Setting credit limit positive at least $20 dollar or making an payment to the customer.

-- Expected result:
Change rate plan coming with PIN_ERR_CREDIT_LIMIT_EXCEEDED

Cause

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 hundreds of Community platforms