Dm_vertex Is Rounding Tax Rate To 5 Decimal Places But Comtax Ctq Series 6 Supports More Decimals (Doc ID 2218475.1)

Last updated on JANUARY 30, 2017

Applies to:

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

Symptoms

On : 7.5.0.16.0 version, Taxation

dm_vertex is rounding tax rate to 5 decimal places but Comtax ctq series 6 supports more decimals.

ACTUAL BEHAVIOR
---------------
ctq currently stores tax rates with a precision up to 8 decimal places.
The rate is rounded in the dm_vertex to 5 decimal places and ultimately stored with this precision in the event_tax_jurisdiction_t table.

As a result the tax amount as calculated by vertex and stored in tax_jurisdiction_t, can no longer be reconciled with using the tax rate in the same table.

EXPECTED BEHAVIOR
-----------------------
The dm_vertex code should not round Tax rate 5 Decimal Places, this should be configurable in either the pin.conf or a business parameter to allow tax rate with more precision.

STEPS
-----------------------
Example:
The city tax for geocode 320010020 is defined in ctq table RTERDD as 0.011875, but is returned as 0.01188 from dm_vertex

0 PIN_FLD_POID POID [0] 0.0.0.1 -1 0
0 PIN_FLD_TAXES ARRAY [0] allocated 20, used 4
1 PIN_FLD_TAX_CODE STR [0] "9001001"
1 PIN_FLD_SHIP_TO STR [0] "Albuquerque ;NM ;87187-7200 ;USA;[320010020,1,0]"
1 PIN_FLD_LOCATION_MODE ENUM [0] 0
1 PIN_FLD_AMOUNT_TAXED DECIMAL [0] 34.1
0 PIN_FLD_INCORPORATED_FLAG ENUM [0] 0
0 PIN_FLD_CURRENCY INT [0] 840

Execute PCM_OP_RATE_TAX_CALC:
...
1 PIN_FLD_SUBTOTAL ARRAY [0] allocated 20, used 13
2 PIN_FLD_TYPE ENUM [0] 3
2 PIN_FLD_NAME STR [0] "US; NM; BERNALILLO; ALBUQUERQUE; ; [320010020]"
2 PIN_FLD_TAX DECIMAL [0] 0.40 2 PIN_FLD_PERCENT DECIMAL [0] 0.01188 2 PIN_FLD_AMOUNT_GROSS DECIMAL [0] 34.10
2 PIN_FLD_AMOUNT_TAXED DECIMAL [0] 34.10
2 PIN_FLD_AMOUNT_EXEMPT DECIMAL [0] 0.00
2 PIN_FLD_SUBTYPE ENUM [0] 99
2 PIN_FLD_DESCR STR [0] "Sales Tax"
....

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