About Changing Rounding Rules for Taxation in config_beid_rules_t (Doc ID 2899582.1)

Last updated on SEPTEMBER 29, 2022

Applies to:

Goal

On : 12.0.0.1.0 version, Core Billing of Billing and Revenue Management (BRM)

Rounding has been changed from 2 to 4 decimals for taxation by updating the table config_beid_rules_t. This change has been reverted later on.

Actual behavior:
After switching back to 2 decimals, the existing accounts (which were billed previously) are still having 4 decimals in bill_t.
For freshly created accounts, the values stored in bill_t are of 2 decimal place.

Expected behavior:
Post reverting, all entries created in database should be rounded to 2 decimal place instead of 4.

STEPS
-----------------------
1. update the table config_beid_rules_t with this query:

   update pin.config_beid_rules_t set rounding=4 where rec_id2=702 and processing_stage=2 and obj_id0 in (select obj_id0 from pin.config_beid_balances_t where rec_id = 702);

2. revert the rounding with this query:

    update pin.config_beid_rules_t set rounding=2 where rec_id2=702 and processing_stage=2 and obj_id0 in (select obj_id0 from pin.config_beid_balances_t where rec_id = 702);


Should all entries created in the database be rounded to 2 decimal place instead of 4 post reverting?
 

Solution

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