100% Adjustment On Cycle Fees With Multiple Taxes (Doc ID 2206341.1)

Last updated on DECEMBER 05, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.15.0 to 7.5.0.15.0 [Release 7.5.0]
Information in this document applies to any platform.

Symptoms

On : 7.5.0.15.0 version, Accounts Receivable (AR)

ACTUAL BEHAVIOR
---------------
BRM is applying incorrect adjustments on tax.

Customer has a cycle fee with the following balance impacts:
event_poid, amount, rate_tag, product_obj_type,amount_taxed,tax_amount_exempt,tax_rate
/event/billing/product/fee/cycle/cycle_forward_monthly 300492129828951426, -17.16, Pricing, /product
/event/billing/product/fee/cycle/cycle_forward_monthly 300492129828951426, 5.15, Pricing, /discount
/event/billing/product/fee/cycle/cycle_forward_monthly 300492129828951426, -1.2, Tax,,-12.01,,0.09975
/event/billing/product/fee/cycle/cycle_forward_monthly 300492129828951426, -0.6, Tax,,-12.01,,0.05

Did a 100% event level debit adjustment on it:
# number of field entries allocated 20, used 7
0 PIN_FLD_POID POID [0] 0.0.0.1 /account 4292574 0
0 PIN_FLD_PROGRAM_NAME STR [0] "Chargeback"
0 PIN_FLD_DESCR STR [0] "[Chargeback Adjustment]"
0 PIN_FLD_REASON_DOMAIN_ID INT [0] 38
0 PIN_FLD_REASON_ID INT [0] 3
0 PIN_FLD_ADJUSTMENT_INFO ARRAY [0] allocated 20, used 3
1 PIN_FLD_RESOURCE_ID INT [0] 124
1 PIN_FLD_PERCENT DECIMAL [0] -100
1 PIN_FLD_FLAGS INT [0] 8
0 PIN_FLD_EVENTS ARRAY [0] allocated 20, used 1
1 PIN_FLD_POID POID [0] 0.0.0.1 /event/billing/product/fee/cycle/cycle_forward_monthly 300492129828951426 0

And the output is:
# number of field entries allocated 20, used 7
0 PIN_FLD_POID POID [0] 0.0.0.1 /account 4292574 0
0 PIN_FLD_RESULT ENUM [0] 1
0 PIN_FLD_ADJUSTMENT_INFO ARRAY [0] allocated 20, used 6
1 PIN_FLD_RESOURCE_ID INT [0] 124
1 PIN_FLD_AMOUNT DECIMAL [0] -12.01
1 PIN_FLD_AMOUNT_TAXED DECIMAL [0] -1.8
1 PIN_FLD_DISCOUNT DECIMAL [0] 5.15
1 PIN_FLD_AMOUNT_ADJUSTED DECIMAL [0] -12.01
1 PIN_FLD_AMOUNT_TAX_ADJUSTED DECIMAL [0] -0.600000000000000


EXPECTED BEHAVIOR
-----------------------
Expecting AMOUNT_TAX_ADJUSTED to be 1.8 (there were 2 taxes that need to be adjusted 1.2 and .6)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1) Create an account with 2 tax codes (robj of purchase event - MCF.robj)
2) change pvt by 1 day and cancel the product using PCM_OP_BILL_CANCEL_PRODUCT so that the products are prorated (robj of event attached - CANCEL_PRODUCT.robj)
3) perform 100% debit event adjustment on the event generated by cancel_product (CM pinlog cm.pinlog_event_lev_adj and robj of adjustment attached - event_adjustment.robj)

After event adjustment the account still has a due of -1.89, which is Tax2 component.

0 PIN_FLD_ADJUSTMENT_INFO ARRAY [0] allocated 20, used 6
1 PIN_FLD_RESOURCE_ID INT [0] 124
1 PIN_FLD_AMOUNT DECIMAL [0] -18.9
1 PIN_FLD_AMOUNT_TAXED DECIMAL [0] -2.83
1 PIN_FLD_DISCOUNT DECIMAL [0] 8.1
1 PIN_FLD_AMOUNT_ADJUSTED DECIMAL [0] -18.90
1 PIN_FLD_AMOUNT_TAX_ADJUSTED DECIMAL [0] -0.940000000000000

purchase event--> pricing : 18.9 Tax1 : 0.94 Tax2 : 1.89
Cancel event --> pricing : -18.9 Tax1 : -0.94 Tax2 : -1.89
Adjustment event --> pricing : 18.9 Tax1 : 0.94

The behavior is same even when the adjustment is being passed from OBRM CC.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Customer is in E2E testing stage and trying to do a PRODUCTION release in the mid November.
Since this defect has a financial and end-user impact this defect will become a blocker if not resolved.

Changes

 When full adjustment was triggered on an event with negative balance impacts, having multiple tax jurisdictions, the adjustment tax amount was calculated incorrectly

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