Amount Refunded Is Based On Scaled Amount Configured In The Product But Not The Overridden Amount (Doc ID 1481619.1)

Last updated on SEPTEMBER 24, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.0.0.0 to 7.4.0.0.0 [Release 7.3.0 to 7.4.0]
All Platforms

Symptoms

1. Create a product with scaled amount as $9 and bill in advance as 2 months.
2. Create an account on 5th March with the deal containing the above product. While purchasing the product, select the override amount as $4 and end_date set to 1st June.
Following are the balance impacts:

Amount   Event   Impact_type   Resource_id   start_t   end_t
3.35  /event/billing/product/fee/cycle/cycle_forward_monthly  1  840   06-MAR-12 05:30:00   01-APR-12 05:30:00
8      /event/billing/product/fee/cycle/cycle_forward_monthly  1  840    01-APR-12 05:30:00   01-JUN-12 05:30:00

 

3. On 1st April, run the billing.
4. Use PCM_OP_SUBSCRIPTION_SET_PRODINFO to nullify the end_dates set.

# PCM_OP_SUBSCRIPTION_SET_PRODINFO input flist
# number of field entries allocated 20, used 3
0 PIN_FLD_POID POID [0] 0.0.0.1 /account 1748178 0
0 PIN_FLD_PROGRAM_NAME STR [0] "update_purchase_product.sh"
0 PIN_FLD_PRODUCTS ARRAY [0] allocated 20, used 15
1 PIN_FLD_CYCLE_END_T TSTAMP [0] (0)
1 PIN_FLD_STATUS_FLAGS INT [0] 0
1 PIN_FLD_OFFERING_OBJ POID [0] 0.0.0.1 /purchased_product 1748946 0
1 PIN_FLD_PRODUCT_OBJ POID [0] 0.0.0.1 /product 1720271 0
1 PIN_FLD_PURCHASE_START_UNIT INT [0] 0
1 PIN_FLD_PURCHASE_FEE_AMT DECIMAL [0] 0
1 PIN_FLD_PURCHASE_END_T TSTAMP [0] (0)
1 PIN_FLD_USAGE_END_DETAILS INT [0] 0
1 PIN_FLD_CYCLE_END_DETAILS INT [0] 0
1 PIN_FLD_PURCHASE_END_DETAILS INT [0] 0
1 PIN_FLD_USAGE_START_DETAILS INT [0] 1
1 PIN_FLD_CYCLE_START_DETAILS INT [0] 1
1 PIN_FLD_PURCHASE_START_DETAILS INT [0] 1
1 PIN_FLD_USAGE_START_UNIT INT [0] 0
1 PIN_FLD_CYCLE_START_UNIT INT [0] 0

Following are the balance impacts:


Amount Event Impact_type Resource_id start_t end_t
3.35 /event/billing/product/fee/cycle/cycle_forward_monthly 1 840 06-MAR-12 05:30:00 01-APR-12 05:30:00
8 /event/billing/product/fee/cycle/cycle_forward_monthly 1 840 01-APR-12 05:30:00 01-JUN-12 05:30:00
9 /event/billing/product/fee/cycle/cycle_forward_monthly 1 840 01-JUN-12 05:30:00 01-JUL-12 05:30:00

5. On 15th April, cancel the product.

Following are the balance impacts:

Amount Event Impact_type Resource_id start_t end_t
3.35 /event/billing/product/fee/cycle/cycle_forward_monthly 1 840 06-MAR-12 05:30:00 01-APR-12 05:30:00
8 /event/billing/product/fee/cycle/cycle_forward_monthly 1 840 01-APR-12 05:30:00 01-JUN-12 05:30:00
9 /event/billing/product/fee/cycle/cycle_forward_monthly 1 840 01-JUN-12 05:30:00 01-JUL-12 05:30:00
-4.87 /event/billing/product/fee/cycle/cycle_forward_monthly 1 840 15-APR-12 13:30:22 01-MAY-12 05:30:00
-9 /event/billing/product/fee/cycle/cycle_forward_monthly 1 840 01-MAY-12 05:30:00 01-JUN-12 05:30:00

Here, the amount refunded is not from the overridden amount configured in step 2 but from the scaled amount that is configured in the product i.e. $9. Expected result is, it should refund based on overridden amount of $4. Also, the refund for 1st June to 1st July is not done.

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