Tax Percentage Of Dm_vertex Output Is Getting Rounded To 2 Digit Decimal Value

(Doc ID 953365.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.0.0.0 to 7.3.1.0.0 [Release 7.3.0 to 7.3.1]
Oracle Solaris on SPARC (32-bit)

Symptoms

-- Problem Statement:
In Q series dm_vertex output PIN_FLD_TAX, PIN_FLD_PERCENT inside the Tax array is rounded to 2 digit decimal value. where it should be a 4/6 digit decimal value.

L Series:
dm_vertex_ctx_process input:
# number of field entries allocated 20, used 19
0 PIN_FLD_POID POID [0] 0.0.8.1 /_tax_db 0 0
0 PIN_FLD_START_T TSTAMP [0] (1255889870) Sun Oct 18 11:17:50 2009
0 PIN_FLD_END_T TSTAMP [0] (1255889841) Sun Oct 18 11:17:21 2009
0 PIN_FLD_ACCOUNT_NO STR [0] "0.0.0.1-9353"
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] 1
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] "vat_cert_US"
0 PIN_FLD_NAME STR [0] "TS1"
0 PIN_FLD_REGULATED_FLAG ENUM [0] 0
0 PIN_FLD_EVENT_TYPE STR [0] "/event/billing/product/fee/purchase"
0 PIN_FLD_ROUNDING INT [0] 3
0 PIN_FLD_ROUNDING_MODE ENUM [0] 5
0 PIN_FLD_TAXPKG_TYPE ENUM [0] 4
0 PIN_FLD_TAXPKG_TYPE ENUM [0] 4
0 PIN_FLD_TAXES ARRAY [0] allocated 20, used 12
1 PIN_FLD_TAX_CODE STR [0] "EU_VTX_1501"
1 PIN_FLD_AMOUNT_TAXED DECIMAL [0] 599
1 PIN_FLD_BAL_GRP_OBJ POID [0] 0.0.0.1 /balance_group 38835894 14
1 PIN_FLD_GL_ID INT [0] 20320
1 PIN_FLD_SHIP_TO STR [0] "SAN JOSE;CA;95129;USA;[050853070000,1,1]"
1 PIN_FLD_SHIP_FROM STR [0] "SAN JOSE;CA;95129;USA;[050853070000,1,1]"
1 PIN_FLD_ORDER_ORIGIN STR [0] "SAN JOSE;CA;95129;USA;[050853070000,1,1]"
1 PIN_FLD_ORDER_ACCEPT STR [0] "SAN JOSE;CA;95129;USA;[050853070000,1,1]"
1 PIN_FLD_LOCATION_MODE ENUM [0] 1
1 PIN_FLD_TAXCODE_MAP STR [0] "EU_VTX_1501 : C : 15 : 01 : S : : "
1 PIN_FLD_ELAPSED_TIME TSTAMP [0] (-29) <bad value>
1 PIN_FLD_INTERNATIONAL_IND INT [0] 1
D Wed Sep 16 15:45:08 2009 rbill-ide01 dm_vertex:6062 dm_vertex.c:2645
1:rbill-ide01:testnap:22942:1:502:1253141108:1

dm_vertex_ctx_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 4
1 PIN_FLD_TAXPKG_TYPE ENUM [0] 4
1 PIN_FLD_SUBTOTAL ARRAY [0] allocated 20, used 9
2 PIN_FLD_TYPE ENUM [0] 2
2 PIN_FLD_NAME STR [0] "US; CA; SANTA CLARA; SAN JOSE; 95129; [050853070000]"
2 PIN_FLD_TAX DECIMAL [0] 11.980
2 PIN_FLD_PERCENT DECIMAL [0] 0.02000
2 PIN_FLD_AMOUNT_GROSS DECIMAL [0] 599.000
2 PIN_FLD_AMOUNT_TAXED DECIMAL [0] 599.000
2 PIN_FLD_AMOUNT_EXEMPT DECIMAL [0] 0.000
2 PIN_FLD_SUBTYPE ENUM [0] 99
2 PIN_FLD_DESCR STR [0] "Sales Tax"
1 PIN_FLD_SUBTOTAL ARRAY [1] allocated 20, used 9
2 PIN_FLD_TYPE ENUM [0] 1

 

Q Series:

dm_vertex_ctq_process input:
# number of field entries allocated 20, used 19
0 PIN_FLD_POID POID [0] 0.0.8.1 /_tax_db 0 0
0 PIN_FLD_START_T TSTAMP [0] (1255889870) Sun Oct 18 11:17:50 2009
0 PIN_FLD_END_T TSTAMP [0] (1255889841) Sun Oct 18 11:17:21 2009
0 PIN_FLD_ACCOUNT_NO STR [0] "0.0.0.1-9353"
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] 1
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] "vat_cert_US"
0 PIN_FLD_NAME STR [0] "TS1"
0 PIN_FLD_REGULATED_FLAG ENUM [0] 0
0 PIN_FLD_EVENT_TYPE STR [0] "/event/billing/product/fee/purchase"
0 PIN_FLD_ROUNDING INT [0] 3
0 PIN_FLD_ROUNDING_MODE ENUM [0] 5
0 PIN_FLD_TAXPKG_TYPE ENUM [0] 4
0 PIN_FLD_TAXPKG_TYPE ENUM [0] 4
0 PIN_FLD_TAXES ARRAY [0] allocated 20, used 12
1 PIN_FLD_TAX_CODE STR [0] "EU_VTX_1501"
1 PIN_FLD_AMOUNT_TAXED DECIMAL [0] 599
1 PIN_FLD_BAL_GRP_OBJ POID [0] 0.0.0.1 /balance_group 38835894 14
1 PIN_FLD_GL_ID INT [0] 20320
1 PIN_FLD_SHIP_TO STR [0] "SAN JOSE;CA;95129;USA;[050853070000,1,1]"
1 PIN_FLD_SHIP_FROM STR [0] "SAN JOSE;CA;95129;USA;[050853070000,1,1]"
1 PIN_FLD_ORDER_ORIGIN STR [0] "SAN JOSE;CA;95129;USA;[050853070000,1,1]"
1 PIN_FLD_ORDER_ACCEPT STR [0] "SAN JOSE;CA;95129;USA;[050853070000,1,1]"
1 PIN_FLD_LOCATION_MODE ENUM [0] 1
1 PIN_FLD_TAXCODE_MAP STR [0] "EU_VTX_1501 : C : 15 : 01 : S : : "
1 PIN_FLD_ELAPSED_TIME TSTAMP [0] (-29) <bad value>
1 PIN_FLD_INTERNATIONAL_IND INT [0] 1

dm_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 4
1 PIN_FLD_TAXPKG_TYPE ENUM [0] 4
1 PIN_FLD_SUBTOTAL ARRAY [0] allocated 20, used 9
2 PIN_FLD_TYPE ENUM [0] 2
2 PIN_FLD_NAME STR [0] "US; CA; SANTA CLARA; SAN JOSE; ; [050853070]"
2 PIN_FLD_TAX DECIMAL [0] 11.98
2 PIN_FLD_PERCENT DECIMAL [0] 0.02
2 PIN_FLD_AMOUNT_GROSS DECIMAL [0] 599.000
2 PIN_FLD_AMOUNT_TAXED DECIMAL [0] 599.000
2 PIN_FLD_AMOUNT_EXEMPT DECIMAL [0] 0.000
2 PIN_FLD_SUBTYPE ENUM [0] 99
2 PIN_FLD_DESCR STR [0] "Sales Tax"
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; SANTA CLARA; SAN JOSE; ; [050853070]"
2 PIN_FLD_TAX DECIMAL [0] 43.43
2 PIN_FLD_PERCENT DECIMAL [0] 0.07
2 PIN_FLD_AMOUNT_GROSS DECIMAL [0] 599.000
2 PIN_FLD_AMOUNT_TAXED DECIMAL [0] 599.000
2 PIN_FLD_AMOUNT_EXEMPT DECIMAL [0] 0.000
2 PIN_FLD_SUBTYPE ENUM [0] 99
2 PIN_FLD_DESCR STR [0] "Sales Tax"
1 PIN_FLD_TAX DECIMAL [0] 55.410
2 PIN_FLD_NAME STR [0] "US; CA; SANTA CLARA; SAN JOSE; 95129; [050853070000]"
2 PIN_FLD_TAX DECIMAL [0] 37.438
2 PIN_FLD_PERCENT DECIMAL [0] 0.06250
2 PIN_FLD_AMOUNT_GROSS DECIMAL [0] 599.000
2 PIN_FLD_AMOUNT_TAXED DECIMAL [0] 599.000
2 PIN_FLD_AMOUNT_EXEMPT DECIMAL [0] 0.000
2 PIN_FLD_SUBTYPE ENUM [0] 99
2 PIN_FLD_DESCR STR [0] "Sales Tax"
1 PIN_FLD_TAX DECIMAL [0] 49.418


-- Steps To Reproduce:
1. Run the PCM_OP_RATE_TAX_CALC opcode in Q series vertex with the input flist attached.
2. Check the output flist PIN_FLD_TAX, PIN_FLD_PERCENT inside the Tax array is rounded to 2 digit
decimal value.

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