Billing Time Taxation In-Correct When Best Pricing Feature Is Enabled (Doc ID 1345387.1)

Last updated on AUGUST 26, 2011

Applies to:

Oracle Communications Billing and Revenue Management - Version: 7.4.0.0.0 and later   [Release: 7.4.0 and later ]
Information in this document applies to any platform.

Symptoms

OP_RATE_TAX_CALC does not consider the best-price for taxation. Instead, the old base deal price is considered for taxation.

Steps to Reproduce :

  1. enable best pricing business param , best_pricing
  2. create product p1 , /service/ip, 100$ MCF , flat tax 10% , apply at billing time
  3. create product p2 , /service/ip , 50$ MCF , flat tax 10% , apply at billing time
  4. create deal d2 with p2
  5. create deal d1 with p1 and select d2 as alternate deal , under the best pricing tab , and ensure to select 'One-time credit adjustment' and not 'Rerate affected events'
  6. 16 June : create account and purchase d1
  7. 16 July : run pin_bill_accts
  8. see events generated :
    /event/billing/product/fee/cycle/cycle_forward_monthly 100
    /event/billing/best_pricing -100
    /event/billing/best_pricing 50
    /event/billing/product/fee/cycle/cycle_forward_monthly 100
    /event/billing/cycle/tax 20 <---------------- this should be 15 ( 10% tax )
  9. 16 August : run pin_bill_accts
  10. see events below :
    /event/billing/product/fee/cycle/cycle_forward_monthly 100
    /event/billing/best_pricing -100
    /event/billing/best_pricing 50
    /event/billing/cycle/tax 10 <------------- this should be 5 ( 10% tax on 50$)
  11. See below input flist to op_rate_tax_calc :

    ~~~
    op_rate_tax_calc input flist
    # number of field entries allocated 20, used 15
    0 PIN_FLD_TAXES ARRAY [0] allocated 20, used 11
    1 PIN_FLD_RESOURCE_ID INT [0] 840
    1 PIN_FLD_TAX_CODE STR [0] "user_code"
    1 PIN_FLD_BAL_GRP_OBJ POID [0] 0.0.0.1 /balance_group 1066974 8
    1 PIN_FLD_ORDER_ORIGIN STR [0] "Cupertino;CA;95014;US"
    1 PIN_FLD_ORDER_ACCEPT STR [0] "Cupertino;CA;95014;US"
    1 PIN_FLD_SHIP_FROM STR [0] "Cupertino;CA;95014;US"
    1 PIN_FLD_SHIP_TO STR [0] "bp_3;bp_3;bp_3;in"
    1 PIN_FLD_GL_ID INT [0] 0
    1 PIN_FLD_LOCATION_MODE ENUM [0] 0
    1 PIN_FLD_INTERNATIONAL_IND INT [0] 0
    1 PIN_FLD_AMOUNT_TAXED DECIMAL [0] 100 <--------------------- this should be 50
    0 PIN_FLD_POID POID [0] 0.0.0.1 /account 1066718 0
    ...
    ~~~

Note : By using the option (under best pricing tab in pricing center ) 'Rerate affected events' , the results are good.

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