Pin_rerate Calc-Only Mode Does Not Work For Comprehensive Rerating (Doc ID 1292152.1)

Last updated on JULY 04, 2011

Applies to:

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

Symptoms

In a comprehensive rerating setup when we rerate an account in calc-only mode, it does not work correctly, that is, account is rerated correctly, but database is updated as well (which is not expected).

Steps to reproduce :
  1. created a product for /service/t/g/telephony , MCF 50$ and delayed session event
  2. created account with the above product (on 01 Jan 2020 for example)
  3. move pin_virtual_time(pvt) a couple of days ahead
  4. change MCF to 100$
  5. move pvt a couple of days ahead
  6. check the balance with:
    "select CURRENT_bal from bal_grp_sub_bals_t where obj_id0=(select poid_id0 from bal_grp_t where account_obj_id0=<account poid>);"
  7. output of the above query is = 50$
  8. run the following commands now to perform comprehensive rerating :

    pin_rerate -a <account poid> -c -t 01/01/2020
    pin_rerate -process jobs
    pin_rerate -process queue
    pin_rerate -rerate -l s
    pin_rerate -process queue
    pin_rerate -process recycle

  9. check the balance with the same query . Output = 100$

Expected : the database should not get updated and balance should remain 50$

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