Valid_to Of Non-currency Resource Is Not Updated When Respective Deal Is Cancelled (Doc ID 1967063.1)

Last updated on APRIL 13, 2023

Applies to:

Symptoms

BRM 7.5.0.8.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.

ACTUAL BEHAVIOR
----------------------
Valid_to is not updated to the cancel date immediately and refund is happening.

EXPECTED BEHAVIOR
-----------------------
Valid_to should be updated to cancel date whenever deal cancel with end_t date and refund should not happen.

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.