PIN_FLD_AMOUNT_TAXED Value Is Different When Commtax Q Series Is Used (Doc ID 803756.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version: 7.3.0.0.0 and later   [Release: 7.3.0 and later ]
Oracle Solaris on SPARC (32-bit)
Sun Solaris SPARC (32-bit)

Symptoms

COMMTAX Q series version is not populating the right amount in the output flist from dm_vertex

Steps To Reproduce

1) Set up Commtax Q series as per documentation
2) Make the necessary changes in the cm and dm_vertex pin.conf file.
3) Restart the BRM services and dm_vertex service (stop_dm_vertex;start_dm_vertex).
5)Create a product using Pricing Center mentioning below points-
Supplier ID – Interweb (“Detailed Product Info” tab)
Under “Taxes” Event time, ct_direct (default in taxcodes_map)
MCF - $30
6)Create Deal and Plan using above product.
7)Create accounts by using above created Plan with following addresses –
Sunnyvale, CA, 94086, US – Tax% - 0.08

It can be seen that the tax are getting calculated correctly but PIN_FLD_Amount_Taxed Value is different:

dm_vertex_process input
# number of field entries allocated 20, used 18
0 PIN_FLD_POID POID [0] 0.0.8.1 /_tax_db 0 0
0 PIN_FLD_START_T TSTAMP [0] (1071255544) Fri Dec 12 10:59:04 2003
0 PIN_FLD_END_T TSTAMP [0] (1071255544) Fri Dec 12 10:59:04 2003
0 PIN_FLD_ACCOUNT_NO STR [0] "0.0.0.1-1546684"
0 PIN_FLD_CURRENCY INT [0] 840
0 PIN_FLD_CURRENCY_NAME STR [0] "USD"
0 PIN_FLD_INCORPORATED_FLAG ENUM [0] 0
0 PIN_FLD_RESIDENCE_FLAG ENUM [0] 0
0 PIN_FLD_VAT_CERT STR [0] ""
0 PIN_FLD_TAX_SUPPLIER INT [0] 1
0 PIN_FLD_VATINFO ARRAY [0] allocated 20, used 2
1 PIN_FLD_CANON_COUNTRY STR [0] "US"
1 PIN_FLD_VAT_CERT STR [0] "US4567890"
0 PIN_FLD_NAME STR [0] "INTERWEB"
0 PIN_FLD_REGULATED_FLAG ENUM [0] 0
0 PIN_FLD_EVENT_TYPE STR [0]
"/event/billing/product/fee/cycle/cycle_forward_monthly"
0 PIN_FLD_ROUNDING INT [0] 2
0 PIN_FLD_ROUNDING_MODE ENUM [0] 5
0 PIN_FLD_TAXPKG_TYPE ENUM [0] 4
0 PIN_FLD_TAXES ARRAY [0] allocated 20, used 11
1 PIN_FLD_TAX_CODE STR [0] "ct_direct"
1 PIN_FLD_AMOUNT_TAXED DECIMAL [0] 30.00    -----------------> value is 30.00
1 PIN_FLD_BAL_GRP_OBJ POID [0] 0.0.0.1 /balance_group 1544316 1
1 PIN_FLD_GL_ID INT [0] 0
1 PIN_FLD_SHIP_TO STR [0] "Cupertino;CA;95014;US"
1 PIN_FLD_SHIP_FROM STR [0] "Pleasanton;CA;94588;US"
1 PIN_FLD_ORDER_ORIGIN STR [0] "Pleasanton;CA;94588;US"
1 PIN_FLD_ORDER_ACCEPT STR [0] "Pleasanton;CA;94588;US"
1 PIN_FLD_LOCATION_MODE ENUM [0] 0
1 PIN_FLD_TAXCODE_MAP STR [0] "ct_direct : C : 01 : 01 : S : : "
1 PIN_FLD_ELAPSED_TIME TSTAMP [0] (0) <null>
D Fri Dec 12 10:59:08 2003 zelda dm_vertex:22997 dm_vertex.c:4665
1:zelda:cm:13034:1:1301:1235396767:2

dm log:

_vertex_ctq_process output:
# number of field entries allocated 20, used 2
0 PIN_FLD_POID POID [0] 0.0.8.1 /_tax_db 0 0
0 PIN_FLD_TAXES ARRAY [0] allocated 20, used 10
1 PIN_FLD_TAXPKG_TYPE ENUM [0] 4
1 PIN_FLD_SUBTOTAL ARRAY [0] allocated 20, used 9
2 PIN_FLD_TYPE ENUM [0] 1
2 PIN_FLD_NAME STR [0] "US; CA; ALAMEDA; PLEASANTON;
94588; [050012680]"
2 PIN_FLD_TAX DECIMAL [0] 0.20
2 PIN_FLD_PERCENT DECIMAL [0] 0.01
2 PIN_FLD_AMOUNT_GROSS DECIMAL [0] 0.94
2 PIN_FLD_AMOUNT_TAXED DECIMAL [0] 2.34 -----------------> value is 2.34
2 PIN_FLD_AMOUNT_EXEMPT DECIMAL [0] 0.00
2 PIN_FLD_SUBTYPE ENUM [0] 3
2 PIN_FLD_DESCR STR [0] "911"
1 PIN_FLD_SUBTOTAL ARRAY [1] allocated 20, used 9
2 PIN_FLD_TYPE ENUM [0] 1
2 PIN_FLD_NAME STR [0] "US; CA; ALAMEDA; PLEASANTON;
94588; [050012680]"
2 PIN_FLD_TAX DECIMAL [0] 0.03
2 PIN_FLD_PERCENT DECIMAL [0] 0.00
2 PIN_FLD_AMOUNT_GROSS DECIMAL [0] 0.94
2 PIN_FLD_AMOUNT_TAXED DECIMAL [0] 0.94
2 PIN_FLD_AMOUNT_EXEMPT DECIMAL [0] 0.00
2 PIN_FLD_SUBTYPE ENUM [0] 4
2 PIN_FLD_DESCR STR [0] "PUC Tax"
1 PIN_FLD_SUBTOTAL ARRAY [2] allocated 20, used 9
2 PIN_FLD_TYPE ENUM [0] 1
2 PIN_FLD_NAME STR [0] "US; CA; ALAMEDA; PLEASANTON;
94588; [050012680]"
2 PIN_FLD_TAX DECIMAL [0] 0.47
2 PIN_FLD_PERCENT DECIMAL [0] 0.02
2 PIN_FLD_AMOUNT_GROSS DECIMAL [0] 0.94
2 PIN_FLD_AMOUNT_TAXED DECIMAL [0] 0.94
2 PIN_FLD_AMOUNT_EXEMPT DECIMAL [0] 0.00
2 PIN_FLD_SUBTYPE ENUM [0] 40
2 PIN_FLD_DESCR STR [0] "USF Surchge"
1 PIN_FLD_SUBTOTAL ARRAY [3] allocated 20, used 9
2 PIN_FLD_TYPE ENUM [0] 1
2 PIN_FLD_NAME STR [0] "US; CA; ALAMEDA; PLEASANTON;
94588; [050012680]"
2 PIN_FLD_TAX DECIMAL [0] 0.05
2 PIN_FLD_PERCENT DECIMAL [0] 0.00
2 PIN_FLD_AMOUNT_GROSS DECIMAL [0] 0.94
2 PIN_FLD_AMOUNT_TAXED DECIMAL [0] 0.94
2 PIN_FLD_AMOUNT_EXEMPT DECIMAL [0] 0.00
2 PIN_FLD_SUBTYPE ENUM [0] 41
2 PIN_FLD_DESCR STR [0] "TRS Surchge"
1 PIN_FLD_SUBTOTAL ARRAY [4] allocated 20, used 9
2 PIN_FLD_TYPE ENUM [0] 1
2 PIN_FLD_NAME STR [0] "US; CA; ALAMEDA; PLEASANTON;
94588; [050012680]"
2 PIN_FLD_TAX DECIMAL [0] 0.08
2 PIN_FLD_PERCENT DECIMAL [0] 0.00
2 PIN_FLD_AMOUNT_GROSS DECIMAL [0] 0.94
2 PIN_FLD_AMOUNT_TAXED DECIMAL [0] 0.94
2 PIN_FLD_AMOUNT_EXEMPT DECIMAL [0] 0.00
2 PIN_FLD_SUBTYPE ENUM [0] 42
2 PIN_FLD_DESCR STR [0] "DEAF Surchge"
1 PIN_FLD_SUBTOTAL ARRAY [5] allocated 20, used 9
2 PIN_FLD_TYPE ENUM [0] 1
2 PIN_FLD_NAME STR [0] "US; CA; ALAMEDA; PLEASANTON;
94588; [050012680]"
2 PIN_FLD_TAX DECIMAL [0] 0.73
2 PIN_FLD_PERCENT DECIMAL [0] 0.02
2 PIN_FLD_AMOUNT_GROSS DECIMAL [0] 0.94
2 PIN_FLD_AMOUNT_TAXED DECIMAL [0] 0.94
2 PIN_FLD_AMOUNT_EXEMPT DECIMAL [0] 0.00
2 PIN_FLD_SUBTYPE ENUM [0] 43
2 PIN_FLD_DESCR STR [0] "High Cost"
1 PIN_FLD_SUBTOTAL ARRAY [6] allocated 20, used 9
2 PIN_FLD_TYPE ENUM [0] 1
2 PIN_FLD_NAME STR [0] "US; CA; ALAMEDA; PLEASANTON;
94588; [050012680]"
2 PIN_FLD_TAX DECIMAL [0] 0.05
2 PIN_FLD_PERCENT DECIMAL [0] 0.00
2 PIN_FLD_AMOUNT_GROSS DECIMAL [0] 0.94
2 PIN_FLD_AMOUNT_TAXED DECIMAL [0] 0.94
2 PIN_FLD_AMOUNT_EXEMPT DECIMAL [0] 0.00
2 PIN_FLD_SUBTYPE ENUM [0] 50
2 PIN_FLD_DESCR STR [0] "Excise Tax"
1 PIN_FLD_SUBTOTAL ARRAY [7] allocated 20, used 9
2 PIN_FLD_TYPE ENUM [0] 0
2 PIN_FLD_NAME STR [0] "US; CA; ALAMEDA; PLEASANTON;
94588; [050012680]"
2 PIN_FLD_TAX DECIMAL [0] 0.94
2 PIN_FLD_PERCENT DECIMAL [0] 0.03
2 PIN_FLD_AMOUNT_GROSS DECIMAL [0] 0.94
2 PIN_FLD_AMOUNT_TAXED DECIMAL [0] 2.34
2 PIN_FLD_AMOUNT_EXEMPT DECIMAL [0] 0.00
2 PIN_FLD_SUBTYPE ENUM [0] 70
2 PIN_FLD_DESCR STR [0] "FET"
1 PIN_FLD_TAX DECIMAL [0] 2.55


It can be seen that the input flist the PIN_FLD_AMOUNT_TAXED is passed as

1 PIN_FLD_AMOUNT_TAXED DECIMAL [0] 30.00

where as in the output flist it is passed as :

PIN_FLD_AMOUNT_TAXED DECIMAL [0] 2.34

which is wrong and values like 0.94 follows after that.

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