My Oracle Support Banner

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

Last updated on FEBRUARY 15, 2024

Applies to:

Oracle Communications Billing and Revenue Management - Version 12.0.0.1.0 and later
Information in this document applies to any platform.

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

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
Goal
Solution


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