Valid_to Of Non-currency Resource Is Not Updated When Respective Deal Is Cancelled
Last updated on DECEMBER 14, 2017
Applies to:Oracle Communications Billing and Revenue Management - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
BRM 188.8.131.52.0 version,
The issue can be reproduced with the following below steps:
01.Aug.2014 - Create a parent account without any deals and child account with 1st as billing date and with any cycle_arrear monthly charging deal.
08.Aug.2014 - Purchase a non-currency resource deal that provides resource one month in advance for child account with start date as 8th Aug 2014. Here it provides non-currency resources for August and September periods with full amount.
02.Sep.2014 - Do billing for both accounts for Aug period. Here it provides non-currency resource for October period.
02.Oct.2014 - Do billing for both accounts for Sept period. Here it provides non-currency resource for November period.
08.Oct.2014 - Cancel the non-currency resource deal with end date as current date using op_subscription_set_prodinfo opcode. Here end dates are updated as 08.Oct.2014 in purchased_product_t table and current_bal of November sub balance is updated to zero with valid_to also set as 01.Nov.2014 but valid_to of October sub balance is not updated to 08.Oct.2014.
02.Nov.2014 - Do billing for both accounts for Oct period. Now the valid_to of October sub balance is updated to 08.Oct.2014 and also the current_bal of October sub balance is prorated where as product is configured not to prorate if purchased or cancelled in the middle of the month.
Valid_to is not updated to the cancel date immediately and refund is happening.
Valid_to should be updated to cancel date whenever deal cancel with end_t date and refund should not happen.
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