Item Adjustment Incorrect Tax Calculation (Doc ID 3003410.1)

Last updated on FEBRUARY 16, 2024

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
In Billing Revenue Management (BRM), the item adjustment with taxes included is not applying the tax adjustment using the original product rate tag for the tax calculations.


EXPECTED BEHAVIOR
-----------------------
The taxes adjusted are not using the tax code of the original item. The requirement is to adjust the taxes associated with the product.


STEPS
-----------------------
1. An account with cycle_arrear item and tax was calculated using below tax code
0 PIN_FLD_BAL_IMPACTS ARRAY [3] allocated 24, used 24
1 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 25807320 6
1 PIN_FLD_AMOUNT DECIMAL [0] 2806.62359453382
1 PIN_FLD_AMOUNT_DEFERRED DECIMAL [0] 0
1 PIN_FLD_AMOUNT_ORIG DECIMAL [0] 0
1 PIN_FLD_BAL_GRP_OBJ POID [0] 0.0.0.1 /balance_group 25804856 0
1 PIN_FLD_DISCOUNT DECIMAL [0] 0
1 PIN_FLD_DISCOUNT_INFO STR [0] ""
1 PIN_FLD_GL_ID INT [0] 10000053
1 PIN_FLD_IMPACT_CATEGORY STR [0] ""
1 PIN_FLD_IMPACT_TYPE ENUM [0] 4
1 PIN_FLD_ITEM_OBJ POID [0] 0.0.0.1 /item/cycle_forward_arrear/<CUSTOM> 25805624 0
1 PIN_FLD_LINEAGE STR [0] ""
1 PIN_FLD_OFFERING_OBJ POID [0] 0.0.0.0 0 0
1 PIN_FLD_OUTSTANDING_AMOUNT DECIMAL [0] 0
1 PIN_FLD_PERCENT DECIMAL [0] 0.2565
1 PIN_FLD_PRODUCT_OBJ POID [0] 0.0.0.0 0 0
1 PIN_FLD_QUANTITY DECIMAL [0] 11295.62359453382
1 PIN_FLD_RATE_OBJ POID [0] 0.0.0.0 0 0
1 PIN_FLD_RATE_TAG STR [0] "Tax"
1 PIN_FLD_RESOURCE_ID INT [0] 9000004
1 PIN_FLD_RESOURCE_ID_ORIG INT [0] 0
1 PIN_FLD_RUM_ID INT [0] 0
1 PIN_FLD_TAX_CODE STR [0] "<TAX_CODE1>"
1 PIN_FLD_TAX_EXEMPTION_CODE STR [0] ""

2. In Billing Care, select account and item to adjust. See that tax adjustment is using a different tax code
0 PIN_FLD_BAL_IMPACTS ARRAY [1] allocated 20, used 14
1 PIN_FLD_IMPACT_TYPE ENUM [0] 4
1 PIN_FLD_RESOURCE_ID INT [0] 986
1 PIN_FLD_GL_ID INT [0] 10000166
1 PIN_FLD_TAX_CODE STR [0] "<TAX_CODE2>"
1 PIN_FLD_RATE_TAG STR [0] "Tax"
1 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 25807320 8
1 PIN_FLD_BAL_GRP_OBJ POID [0] 0.0.0.1 /balance_group 25804856 0
1 PIN_FLD_RATE_OBJ POID [0] 0.0.0.0 0 0
1 PIN_FLD_DISCOUNT DECIMAL [0] 0
1 PIN_FLD_PERCENT DECIMAL [0] 0.142500
1 PIN_FLD_QUANTITY DECIMAL [0] -13172.73469387755
1 PIN_FLD_AMOUNT DECIMAL [0] -1877.11469387755
1 PIN_FLD_AMOUNT_DEFERRED DECIMAL [0] 0
1 PIN_FLD_ITEM_OBJ POID [0] 0.0.0.1 /item/adjustment 25737088 0

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.