About Changing Rounding Rules for Taxation in config_beid_rules_t
(Doc ID 2899582.1)
Last updated on SEPTEMBER 29, 2022
Applies to:Oracle Communications Billing and Revenue Management - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
On : 184.108.40.206.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.
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.
Post reverting, all entries created in database should be rounded to 2 decimal place instead of 4.
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?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document